Originally Posted by
MattBaldry
Just for my input, which is not the greatest, but I have written ID's like this where the order number is only entered when the order is saved. I have an AutoNumber as the main PK and then order number as another PK, but this is only entered when the order is saved. Sage Accounts also works in the same way. We can have 5 users all enter a PO at the same time but the next order number is allocated to the first person to click save, and only when you click save. If the order is not saved, everything is undone and the incomplete record is deleted and leaves your order number sequence as it was. The AutoNumber key may be missing a number, but as this is not used as the order number it does not matter.
~Matt