Access 2000 - I have a db of products with many serial numbers (these are in 2 tables 1:many). Also have a form/subform for data entry.

Most often I need to add several records at a time. For instance, Product A - serial numbers 1 through 15 - each one being its own record. Can't use autonumber because of alpha/numeric combo in serial numbers since they are sometimes assigned by customer.

I'm thinking along the lines of update table query but am looking for any suggestions readers may have.