Scenario - Classroom assignment for course offerings -
|Course ID||Meeting Days||Start Time||End TIme||Classroom|
|CS101||M,W,F||9.00 AM||9.50 AM||Room 1|
|STAT101||M,W,F||11.00 AM||12.00 PM||Room 1|
|CS102||T,R||9.00 AM||10.30 AM||Room 2|
|Stat102||T,R||9.30 AM||10.30 AM||Room 2|
|Engl101||M,W,F||9.00 AM||9.50 AM||Room 3|
|Engl102||W||9.30 AM||10.30 AM||Room 3|
Users do a classroom allocation for the course offerings and generate the above room allocation report towards the end. I need to write a script in FM to flag a course if it overlaps with another day and time and highlight the row with a differnet color for correction. All the data exists on a single data table. In the above example, row 3 and 4 has a time overlap and like wise, row 5 and 6 has a time overlap.
Can please anyone advice me on how write a solution for this scenario on filemaker.