repeating auto incrementing number

Ted Kirkendall
01-08-2001, 01:25 PM
I have an Access database that contains a field that stores an order id number when an order is placed. The field is auto incrementing. However, on more than one occasion I have seen two different tickets with the same number. How can this be and how can I avoid this ever happening again?
thanks alot,
ted

kingesk
01-08-2001, 02:21 PM
I don't know why that may be happening. I was wondering though if in your table that the orderID field is Indexed and and is set to {Yes (No Duplicates)} It may be something else but hope this may help.

Eric

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum