I have a form called store_receipt.
It contains a subform: store_receipt_item on which there are the following fields:
order_id - Text Child/Master linked field
row_id - Text
sku - Text
quantity - Number
adjusted_price - Number
What I need is for the row_id field to start numbering from 0. In other words, for each receipt, the items sold on that receipt begin numbering at 0.
Obviously it can't be an autonumber field and the field has to be text since it's going to be imported into another application. Any thoughts? I have some knowledge of VBA if this helps.
My next approach is to create a separate table for each store_receipt_item, use the autonumber feature and then convert to text with a query. It means a lot of little tables but it could solve the problem.
