Loop exiting

[mattpacman]

I am new to FMP, and am using 5.5 for Mac. I am writing a script that lists due invoices. I want the script to compare the field "Due Date" and the global field "Today Date". If Today Date is after the Due Date, I would like the script to set the field "Due?" to "Yes" , else to "No". I am using a loop, but it runs indefinantly. How should I stop the loop? Is there a way to stop after the last record? Thanks.

 

[Fleer]

a loop is always build like this :

go to record/request/page [first]
loop
...
go to record/request/page [Exit after Last, Next]
end loop

so in order to stop the loop when it reaches it last record, you must always choose 'next' from the specify pull down menu and then a check box will appear where you can choose 'exit after last'

 

[mattpacman]

Thank you. That solved the problem.