I have an FMP6 related DB with records from DB2 displayed in a portal in DB1 indexed by date.

The DB relates to student detentions.

If a student misses a detention I have set up a script that creates a detention on another day using the information from the record on the original detention day...which works!!!

I'm trying to write a script to see if the student already has a detention on the day to be rescheduled.

My script works if the student has or doesn't have a detention on the rescheduled date.

But the script ends on the rescheduled date and I can't work out how to return to the original record on the original detention date.

Can anyone give me some idea abot where to go from here?

TIA

Use a global field to store the record ID of the first record at the beginning of the script. Return to the record ID stored in the global at the end of the script.