Order ID

[mshirwan]

I have an order table that stores orders from different supplier, but how can I have a different order ID for different supplier of product that increases serialy.

i.e general order id for all orders which i have.

another order id for orders by a specific supplier.

 

[Len Boorman]

Have you tried using something like an Autonumber for a basic Order Number and then adding then Supplier ID so you end up with something like


ABC/1
ABC/2
XYZ/3
TYU/4

etc.

Base order number is sequential but not within supplier.

Maybe gives you ideas

Len