Want to update the displayed record based on the date
I have a table with schedule information for several different groups; who's on call each shift/day each week. I enter the on-call schedules into the table several weeks in advance. I need to make only the relevant record, i.e. the one for this particular group for the current week, visible on the display layout. I know I could run a script to archive the old schedules and display the new ones all at once, say at 7:00 on Monday Morning, but the problem is the different offices change on-call schedules at different times. Some change at 7:00, some at 8:00, some at 8:30... Is there a way to change the displayed record/schedule for each group at the correct time? I'm running Filemaker Pro Advance 13 (Not Server) Thanks!