Showing conflicting dates in layout

[imaslowmoose]

Hello,

I run a talent agency and one problem I have with talent is their availability on certain dates.

What I want is for an indicator (maybe a red dot or fill a field red or something) when a specified date conflicts with dates of unavailability I have for certain records.

For example, john smith lets me know he is going out of town next week from 12/7 - 12/10 so I input it into the database. I have a new job that is on 12/8. When I go searching for john smith I want to see something come up that lets me know he is unavailable like a red flag.

Is this possible?

[comment]

When I go searching for john smith I want to see something come up

Well, it depends on where you are at this point. In principle, you could define a relationship between Jobs and Unavailabilities. But from the point-of-view of the Contacts table, all jobs look the same...

[imaslowmoose]

Ok I am going to change my approach at this it looks like it will get too complicated. How do I get a field in a layout to change colors when there are contents within the field?

That way I could just see the red coloring if I put in a date that they are out of town.

[comment]

That should be very easy with conditional formatting:

http://www.filemaker.com/11help/html/edit_layout.10.14.html#1028330

Though it doesn't seem to make much sense (to me), I'm afraid.

[Lee Smith]

Take a look at cobaltsky's, a.k.a. Ray Colligan, Reservation or booking demo http://www.nightwingenterprises.com/demos7/demo705.html

For some additional ideas.

HTH

Lee