AnsweredAssumed Answered

Looping in two tables

Question asked by symbister on May 17, 2013
Latest reply on May 18, 2013 by symbister

Title

Looping in two tables

Post

     Hi again

     I have two tables 'contacts' and 'events' linked by the join table 'contact_event' - easy

     We regularly group contacts together and assign them to an event, by a simple script to loop through a found set of contacts and write a new record in the join table with the eventID - also easy

     What I'd like to enable is a routine to group a cohort of contacts together, then group a cohort of events together, and loop through each contact, within which is a loop through each event, writing a new join record for each combination

     The set of selected events is in the form of a field containing the EventID's, chosen dynamically from a checkbox based on a TO with a conditional value list limited by date

     1. how do I capture the required events individually; and

     2. how do I loop through these within another loop to write a new join record

     as always , any help appreciated

     screen shot of work in progress might help...

Screen_shot_2013-05-17_at_4.12.09_PM.png

Outcomes