AnsweredAssumed Answered

Check Booking Validation - Help!!

Question asked by MitchellJohnson on Nov 11, 2010
Latest reply on Nov 11, 2010 by philmodjunk


Check Booking Validation - Help!!


Hi There Again,

I need some help creating a script for a booking validation, Hopefully you can follow so here goes:

I have a table name "Booking" and a layout to go with it

I have two fields in this table "Booking Time In" & "Booking Time Out"

And there are also two other field "Date" & "Staff Member ID"

What i am trying to create is that when a new booking is created and all the above information has been filled in it checks if there is already a booking with this staff member that would clash with this new one.

So i need a script that will check if that staff member is free to perform this booking.

Hope this is all clear,

Thanks A Lot,