Validating across two fields

[Lee J]

Hi To All

I have a situation where i can't seem to validate against two fields

I'm trying to create a Time and Date entry for a community hall and don't want people to be able to book the same time/date.

So far i have created a number calculation field (DateReq + timeReq) to create a unique number.

Then using a Submit script I copy the value to another field Validation field where i try to "Trap" the error and provide feedback to the user to say it has already been booked.

I have used the Validate options under the Field Definitions but this results in them having to modify the Validate value which means nothing to the user.

I really need to redirect back to the Time or Date field to change.

Hope this is clear

cheers

[Vaughan]

You need to validate the calculation field for uniqueness.

http://www.filemaker.com/ti/104191.html