Resetting an Autonumber

D

Duck

I am trying to create a sales subform for our store. I would like to
have each item in each sale numbered starting at one. In my sales
table I have an order number (OrderNo) and a Item number (ItemNo).
Is there some way to set the ItemNo as an Autonumber which will start
over at 1 for each new OrderNo?
 
J

Jerry Whittle

In a word: No. Autonumbers do not work that way. You'll need to create
something in code to do what you ask.
 
Top