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
It freezes filemaker every time and i am stumped. Thank you in advance