Creating A Field that Notes Time Conflict

[adario]

I'm a FileMaker Novice.

I've created a small database indicating several testing rooms and when they are in use by students. The DB contains several tables (room, equipment, student info, and exam info.

A report shows the times during which students are in a particular room. I'd like to show time conflicts where or not there might be a time conflict (i.e. two students in the room at the same time). Is there any way of doing this?

In the EXAM table, the instructor enters his/her test info (beginning time, date of test, and length of time to take the test), an administrator books the room. If there is a conflict between the beginning of a test time and the end (tests overlapping in a room), I'd like a field to say "time conflict".

Because the calculations I've create seem to refer to one record instead checking all records in the same room on the same day, I can't get a conflict statement to appear.

Thank you for any help you can offer.

Amy }:(

[adario]

WOW! This is really great. It wasn't quite what I was in search of, but I'm going to use it now!!!

I know I presented my query badly... I'm very confused. Here's what I wanted -- I don't know if it's possible.

Rather than stating a duration of time when a room might be in use and thereby setting up the conflict, I wanted FileMaker to let me know WHEN there might be a conflict. In other words, if times during which two students schedule a room overlap, can FileMaker pop up with statement indicating that there seems to be some overlap and suggest the later student schedule another room?

Thanks much for your help

Amy :qwery:

[Fenton]

But that's what my example file did, in the simplest manner possible. There are global fields at the top, date, time start, time end. You put data in. If there is a conflict with existing date-time slots (in the records) then it: 1. shows a message (calculation field), 2. shows the conflicting records in a portal.

If you have more criteria, such as Room, then you add a global for room, and add the criteria to the relationship.

Oops! Big mistake in my example file. I'd used the regular date instead of the global in the relationship. I didn't notice. Deleting earlier post.

[P.S. The globals could be in another table, or their own table. Or in multiple tables, though that doesn't seem likely.]

Time_Conflicts.fp7.zip

Edited June 5, 2007 by Guest

[adario]

THANKS! Sorry about that... I'll give it a try

THANK YOU