Form to add multiple records to table

[jcarstens]

TestMultipleRecords.zipI have a form where I am trying to add multiple records to at a time.

• The form “Form1” pulls data in from two tables
• Table “Orders” is just order details and is pre-populated of the necessary data (No data manipulation will be needed here but the data will need to be displayed on the form)
• Table “OrderItems” is essentially empty in my form, this is the table I want to add data to. The thought be here is that a person will be going though each record and manually adding in the additional information required. Each item could have multiple entries, hence the need to be able to add multiple entries at once.
  
  • I will need the ability to add multiple records per time to the table
  • For each order number, all records will need to have the same Order ID as the original order

I have added a sample DB which I have included narratives to better explain what I am trying to accomplish.
Any help would be greatly appreciated.

[June7]

Consider form/subform arrangement. Review: http://office.microsoft.com/en-us/ac...010098674.aspx