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?