I have a table that lists camera lenses we own [lenses]. The user can click a button and a new window opens displaying a list of quality control entries made for that lens within a portal [lens QC]. A button is clicked on that portal line to open a further window which the user can create a QC check list (or tasks) [advanced lens QC], again within another portal. The fields defined within each task are "task", "status", and "comment". The user can either auto populate a checklist based on a value list, or they can manually add portal (task) lines themselves. Most users auto populate. Upon the user exiting this advanced lens QC window layout (via a button that says Exit) I need two things to happen:

 

1. If no status was entered into the "status" field (which are radio buttons: 'Passed', 'Failed', 'Comments', 'N/A') for that particular task, and comments WERE entered into the "comment" field, FMP must set the "status" field to 'Comments' for each related record this applies to. However, if the "status" field was set to an actual value (for example, 'Passed') and the user still entered comments, then FMP should move onto the next record without changing anything.

 

2. If no status was entered into the "status" field for that particular task, and no comments were entered into the "comment" field either, then FMP should delete those related records.

 

What is the best way to get FMP to check the related fields for these values? What is the most efficient way to "loop" this script?

You would probably want to take a look at the OnRecordCommit script trigger.