October 16, 200322 yr 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
October 16, 200322 yr You need to validate the calculation field for uniqueness. http://www.filemaker.com/ti/104191.html
Create an account or sign in to comment