11 Replies Latest reply on Nov 11, 2010 2:05 PM by philmodjunk

    Check Booking Validation - Help!!

    MitchellJohnson

      Title

      Check Booking Validation - Help!!

      Post

      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,

      Mitch