Remove related info when unchecked
Thanks in advance to PhilModJunk for Loop through filters which got my script working this far. It relates Activities that the user chooses to an Event. I want to modify the script to UNrelate an Activity if it's un-checked. Here's my working script for the relating loop:
Set Variable [$Event; value: EventDetails::__pkEventID]
Set Variable [$ActList; value: EventDetails::checkbox_Activities]
Set Variable [$K ; value: $K +1]
Exit Loop if [$K > ValueCount ($ActList)]
Go to Layout ["Activities for Event" (activities_EVENT)]
Enter Find Mode 
Set Field [activities_EVENT::__pkActivityID; GetValue ($ActList ; $K)]
Set Error Capture [On]
Perform Find 
Set Field [activities_EVENT::_fkEventID ; $Event]
Go to Layout [original layout]
So, if an activity is NOT checked (or is UN-Checked) it won't be in the list ($ActList) and it won't be found with Perform Find. I need to also find related activities that are NOT in $ActList.
I'm going to try a second loop that 1) finds all the related activities, 2) omits the $ActList results, and 3) removes the EventID – but maybe there's an easier way? Any help is much appreciated!