Script: Transferring data between tables
I have three related tables: Managers, Events, and a Join table that joins the two. Each new Event needs to be linked to a subset of the Managers, with a new joint record created in the Join table. I want to automate this process.
I wrote a script that finds the relevant subset of Managers, and then creates that number of new records in Managers-Events (Join).
Now I want to loop through the found set of Managers, sequentially copying each Manager ID # and pasting it into each successive new record in the Join Table.
I have managed to automate this in a cumbersome way by going back and forth between tables and copying and pasting records. The process is clunky and inexplicably leaves some blank records in the Join table. There must be a better way to accomplish this. Thanks for any suggestions.