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,