>Ed,
>
>I think it's very hard to achieve what you're trying to achieve and probably not worth the effort. Your Order number should be a unique key and user should not even see it. If the later is the case, then it doesn't matter if some numbers are skipped.

The Order number should not be the primary key. It should be visible to the users, just as an invoice number should be visible to the users. The primary key/foreign key should not be visible to the user.


>
>>Dear All,
>>
>>I have made a program with a multiple station input say an ‘order’ which will have a unique order number automatically produced by the program once any user choose ‘new’ order. My problem is how could I be able to control this as any user may also opt to cancel or not to continue to process the order input. I want to avoid any order number which were not completed in the table or any order number skipped.
>>
>>Your advise would be greatly appreciated.
>>
>>Thanks.
>>
>>Ed