ajetrumpet
Banned
- Local time
- Today, 08:23
- Joined
- Jun 22, 2007
- Messages
- 5,638
I have attached a sample database that I created to illustrate one way of entering multiple records into a table. It is a typical setup for creating an invoice, which is a good example to use for this.
Each record that is initally entered is housed in a temporary table, and is also shown on the form via a query (subform) that gets its records from the temporary table.
Hope this proves to be a good reference. Enjoy!
Edit
I apologize to anyone who tested this form by entering a record. There was no combo box for the "Carrier" value on the main form, it was only a text box. Values entered into this box that were not in the "Carriers" table were causing the temporary records to be discarded, instead of being appended to the actual orders table. Reason - The values did not have a parent value (in a parent record) on the one side of the table relationship. I have uploaded the corrected file. My apologies for any confusion this may have caused.
Another Edit
I have uploaded all 3 versions of this file, to complement the various work environments.
Each record that is initally entered is housed in a temporary table, and is also shown on the form via a query (subform) that gets its records from the temporary table.
Hope this proves to be a good reference. Enjoy!
Edit
I apologize to anyone who tested this form by entering a record. There was no combo box for the "Carrier" value on the main form, it was only a text box. Values entered into this box that were not in the "Carriers" table were causing the temporary records to be discarded, instead of being appended to the actual orders table. Reason - The values did not have a parent value (in a parent record) on the one side of the table relationship. I have uploaded the corrected file. My apologies for any confusion this may have caused.
Another Edit
I have uploaded all 3 versions of this file, to complement the various work environments.
Attachments
Last edited: