I NEED A MIRACLE

[Tomo1]

I need to create a Employee Holiday board in FileMaker. At the moment it's set out like Microsoft Entourage (Calendar view). It needs to contain traps so if people from the same group clash, a message will appear!! I have had no luck anywhere. Is this possible to achieve and if so HOW!!! Are there any sites I can go to???

[Philland]

I think I might need a little more detail on what you are trying to accomplish, but it sounds do-able.

You can create a group identifier field for each day on the calendar and set validation to unique. This will allow only one record for that day with that group identifier. Possibly you could create case or if/then statement based on the group identifier field along the lines of IF(group identifier = "sales", "DATE RESERVED", . . . etc.

[Tomo1]

It sound pretty simple, but there's alot more to it. Each day is a seperate field. For eg 1 group contains Jill, John and James. Jill already booked off 1.5.2002, now James or John want the same day, if one of there names is entered for that same day as Jill a message will appear? Could you explain what you mean a liitle more?

[Philland]

Your database is going to need to be a bit more complicated to accomplish what you want to do. Each day will require multiple fields. Group identifier fields will need to be created for each line on a given day. If you have 3 groups and no more than one person per group can be out then you need three group id fields. Entry of names will need to be entered off indexed lists so case calculations can be made based on entry. Each name will be entered into a separate field. When a person signs up for a day they must also indicate what group they belong to in the group id field. You then need a calc field that compares the three group field and if any entries match displays an alert.