AnsweredAssumed Answered

How to create new related records for all in a found set

Question asked by AndrewSleeth on Jul 8, 2014
Latest reply on Jul 10, 2014 by SteveMartino

Title

How to create new related records for all in a found set

Post

     I have database with table A and related table B (one-to-many via unique ID) that's used to record commonly occurring actions (from a value list) for the records in A, along with a creation timestamp.

     How might one go about automating the creation of new records in table B simultaneously for every record in a found set in table A, which records the same action from the value list for them all?

     In other words, I have N records in a found set of table A, and I want to create a record in table B of action V1 for all N records, all with one button click.  Any suggestions about an elegant way to script this?

     -- Andrew

Outcomes