Does anyone know the best way to create autonumbers using SQL 7.0 similar to
the following:
First Document ever created in NY where NY = code "01", DocID = 9000001-01
2nd Document ever created in NY = DocID = 9000002-01
First Document created in MD (Code = "02"), DocID = 9000001-02
2nd Document created in MD = 9000002-02
First Drawing created in NY site = DocID = 8000001-01
2nd Drawing in NY = 8000002-01
So grab the doctype (drawing or doc) AND the site off the form, query
against some tables and determine next number, then assign it with the
trailing suffix. Can I use "01" or "02" as some sort of trailer and still
use an identity type field or do I have to define it as integer or alpha
type?
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
