Hi!
I am a bit new to this so I was hoping for some help.
I am building 2 linked forms to fill in data in 2 tables (linked via an ID #).
Basically the first table contains general info to an order:
purchase date, invoice id, customer etc
the second table has the actual invoice info: (the bit i'm worried about)
ship date, order number, etc, except it also has to include the item number.
since all the data in the form 2 is the same for every column EXCEPT item number, is there any way to go along creating the form as if it is one row, and then at the end select (via check boxes or drop downs to select in a table) a pre-selected list of items and have this generate multiple rows in table 2?
I am a bit new to this so I was hoping for some help.
I am building 2 linked forms to fill in data in 2 tables (linked via an ID #).
Basically the first table contains general info to an order:
purchase date, invoice id, customer etc
the second table has the actual invoice info: (the bit i'm worried about)
ship date, order number, etc, except it also has to include the item number.
since all the data in the form 2 is the same for every column EXCEPT item number, is there any way to go along creating the form as if it is one row, and then at the end select (via check boxes or drop downs to select in a table) a pre-selected list of items and have this generate multiple rows in table 2?