0 Replies Latest reply on Oct 9, 2014 10:45 AM by sccardais

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

    sccardais

      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?