AnsweredAssumed Answered

Create new records from every record on a query table occurrence

Question asked by jefro on Feb 6, 2018
Latest reply on Feb 6, 2018 by philmodjunk

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?