AnsweredAssumed Answered

Create monthly recurring import of 3,000 records in related table

Question asked by sccardais on Oct 9, 2014

Title

Create monthly recurring import of 3,000 records in related table

Post

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?

Outcomes