Is it possible to start auto number at a given number? Also I have two different types of data that I will track by different tracking numbers, is it possible to denote an auto number with a leter such as E or I? Thanks.
Check the archives for ways to start autonumber at a predetermined place, or *surprise* Access Help actually has a topic on it.
It is possible to make your primary key an autonumber+ a text field. You cannot make them in the same field however, nor should you try.
Be aware that your data will do this:
E47, E48, D49, E50...
not:
E47, E48, D47, E49.
[This message has been edited by David R (edited 05-16-2002).]