Create monthly recurring import of 3,000 records in related table
Once a month, I want to create / append approximately 3,000 records in a related table.
The primary table is USERS. The related table is MailingHistory. The match field is USER_ID.
Every month, we choose a random group of 3,000 USERS to receive a customer satisfaction survey.
Once the 3,000 USERS have been chosen, I want to create 3,000 new records with their UserID and a unique ListID to the MallingHistory table. We'll use this to prevent sending our USERS too many emails.
How do I create 3,000 new records in the related table - MailingHistory- once I've identified them in USERS?