I was wondering if anyone knows if its possible to format a "autonumber" field using a conditional statement.
For example my current ID is formated like: 00001, 00002, 00003 etc...
I have a column called Deparment that can have 1 of 2 possible entries. If it is the first entry i would like a "C" added to the autonumber to make it "C0001" if it is the second entry, I would like it to be "A0001".
not in an autonumber defined field but you can d\create a compund key
myid = 0001
mydept = c
mycompoundkey = mydept & myid
autonumbers are exactly that - assigned integers
you can also try using the autonumber but not set it as the primary key
when you add a record the autonumber increments and then concantonate any other string to that number and store that value as you primary key