Hi - Im hoping there is a howto someone can point me to for what is probably a common issue.
I have a list of customers in a parent table. I have a list of orders in a child table, along with particulars relating to each order such as colour etc.
I would like to be able to restart the numbering of orders for each customer, so I can quickly view how many orders have been ordered by each customer? At the moment, the order list has a primary key that increments for each order, no matter which customer.
I hope this makes sense and Im really grateful for any help.