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.

Thanks!! <img src=/S/cauldron.gif border=0 alt=cauldron width=20 height=20>