standard Client/Product/Transaction/Lineitem(as join table) ERD.
The FM user first creates a product list, shows it to potential customer, makes changes, then creates an invoice.
My solution is to create a query table of "Available Products". That table can have many PRODUCT records on it and I want a single script to create a LINEITEM record for each PRODUCT record.
I have a script that is on each PRODUCT record adding a LINEITEM :
I don't want my client to have to click a button each record.
How could I create a single script that would add a record on the LINEITEM table for each PRODUCT that occurs on the query table?