Hello James,
In a multi-user environment, that is a risky method for generating sequence numbers. Craig Berntson has an article on his website for generating primary keys that you may find helpful:
http://www.craigberntson.com/Articles/kb006.htm>hey everyone,
>is there a way to look at the last row in a table. what i am trying to do is add on to sequence numbers in a table. i want to look at a table's field, for this example we will call it seqnum, and say something like seqnum + 1 for every new insert i make into the table. this way i keep the numbers in sequential order. any advise would be appreciated. thanks.
Steve Gibson