Help with Nested looping script

[Philip O'Brien]

Hi,

I am looking to create a script which loads a list of facilities (not a problem) out of a facilities table and then loops through them. Again not a problem.

My problem, due to being new to filemaker (I am a Mysql man historically), is that while looping through them it needs to:

Foreach facility; load all events relating to that facility from the events table (not a problem on a one by one basis for me) and then loop through the events and extract MTBO .. etc statistics and write them off to a statistics table to keep 3 month rolling stats on all facilities.

I am having trouble getting my head around the actual embedded loop mechanism. I cant find much about looping on the web and I would appreciate it if anyone had an example of embedded loops I could look at and figue out the structure from.

Thanks.

[comment]

I am not sure why you need to loop through the events in order to "extract MTBO .. etc statistics", but here's one way:

Go to Layout [ Facilities ]

# Find the records you want to use

Go to Record [ First ]

Loop

Go to Related Record [ from Events; Show related only ]

Loop

# do something

Go to Record [ Next; Exit after last ]

End Loop

Go to Layout [ Facilities ]

Go to Record [ Next; Exit after last ]

End Loop