AnsweredAssumed Answered

Looping through Found Sets

Question asked by sccardais on Jun 30, 2014
Latest reply on Jun 30, 2014 by sccardais

Title

Looping through Found Sets

Post

     My question relates to the outline of a script suggested here to help divide my database into random cohorts of 1/12 total records.

     http://forums.filemaker.com/posts/35570589c1?commentId=295871#295871

     Records in my table are assigned one of 8 Categories (text field) and 6 sub-categories (calculation number result). I want to perform a repetitive function on each of the 48 combinations but I'm not sure how to structure the loop in the script step.

     Steps in the Script

         
  •           Find Category 1 AND sub-category 1, perform function
  •      
  •           Find Category 1 AND sub-category 2, perform function
  •      
  •           Find Category 1 AND sub-category 3, perform function
  •      
  •           etc.
  •      
  •            

     Repeating this for a total of 48 combinations of category and sub-categories seems tedious and like an ideal situation for a Loop.

     Is there a way to create a looping process to go through all 48 combinations without having to copy / paste every combination in a script that steps through each in sequence?

Outcomes