Results 1 to 1 of 1
Thread: ADDING SEVERAL RECORDS AT A TIME
2001-04-22, 15:44 #1
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
ADDING SEVERAL RECORDS AT A TIME
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.