need helping how to check for conflict with record

[solarpunk]

Hello,

I am writting simple event schedule. I need to figure out how i check for conflict when someone try to create event for the same city, time, room. Example would be Austin, 3:00pm, room B. if someone try to create a record with the same info, i want a message to pop up and inform the person who is entering that datat that city, time, room are already taking.

[andygaunt]

You could -

Create a concatenation of the fields in a calculated field.

Then, use this in a relationship to check with the IsValid function.

If it is valid then a record previously exists. You can then go to that related record and pull up that information in a dialog box.

[solarpunk]

Do you have example of it that i can take a look at it. i am not very advance when it come FM 6.

Thanks,

Victor