AnsweredAssumed Answered

Order - orderline etc

Question asked by sharpie on Apr 14, 2016
Latest reply on Apr 18, 2016 by sharpie

I have something like an orderline table

 

It has a composite foreign key if that makes a difference.

 

I want to know the best way (if any) to make like a serial number for each orderline on order x e.g. 1,2,3,4 BUT I want the numbering to stay just within each order.  And starts at 1 for a new again for a new order record?

 

Please.

 

Thanks

sharpie

Outcomes