How to create new related records for all in a found set
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?