Jim mac 2012-05-21 01:47:26
I am using VB6/ ADO/ Access 2000 on a win 98 machine
I am building an order entry app and I am using a guid as a record key
my table looks like this;
* OrdersKey guid
OrderNo long auto number
and so on
I am using the guid because I can store it and save myself some
round trips to the database should I need it further down the line.
However, I still need to provide the user with a reference number
and I may wish to use it with child tables like OrderDetails.
This app will also be used in a multi user environment.
I tried coding against a control table from which I could retrieve the next
using a max function. However, in a multi user environment I would get
I also can not increment a control table until the order is updated.
Anyone know of a technique to manage numbering?
Any ideas greatly appreciated.