AnsweredAssumed Answered

noob loop help

Question asked by ericjlindholm on Oct 25, 2011
Latest reply on Oct 26, 2011 by philmodjunk


noob loop help


i have a table "event"  that contains "start date" and end date"


there is a portal in the "event" layout to a table "schedule" that contains the field "date"


in this portal, I want to automatically create a portal row for every date between event::start date and event::end date.


my script reads


Set schedule::date = event::start date

If event::end date is not equal to end date


          go to next portal row 

          replace schedule date with schedule date +1

     end loop if schedule::date = event::end date

end if

It freezes filemaker every time and i am stumped.  Thank you in advance