Number increments on subform

[amerfeld]

Haven't been able to find an answer to this one. I have a subform that is related to the main form by order number. In the subform, user will enter qty received for a po. Because we may not receive entire quantity for po at once, we need to add a number or letter to the end of the order number to indicate more than one received qty. So order number 1234 would be 1234-1 for first quantity, then 1234-2 for second qty. Does anyone have any ideas on how to accomplish this? Thanks for any help. I am using Access 2000.

 

[amerfeld]

Pat:
Thanks for your reply. I didn't explain well, but was going to set up the tables the way you suggested, but was still hoping to get a count of how many shipments came in for that PO. After talking to production, we are going to have to think through if we really need to do this at all.
Thanks again.