I have a new field Date/time which has been changed to be from 9 A.M. - 4 P.M. including an hour break.
I'd like to validate the chosen hour to be booked once no one has booked it at the same date. This will include writing an SQL script which I can do. My problem is in looking for the pages that need to be modified to raise the same red error msg as any other required field.
Can any one help me where to write this SQL and where to add the error validation ?