Hello All,
I am currently creating my holiday booking form but now that the general outline of the form has been created I would like to create some validation before a holiday can be booked.
Below is a screenshot of the form.
Before the user can book a holiday on the system, the database should check whether is available on the following conditions:
Below is the schema for the fields involved in the valiation:
There cannot be more than 2 agents on "Annual Leave" as leave_type off per team (Department: "One").
If they have exceeded there "TotalHoursLeft" then warn the user that the agent has no more allocated holiday
if there are more than 4 people off per system, then warn user that user cannot book (although this can be overidden).
Can any one please give me any ideas on how to do this?
Thank You.
M
________
red head Webcam
I am currently creating my holiday booking form but now that the general outline of the form has been created I would like to create some validation before a holiday can be booked.
Below is a screenshot of the form.
Before the user can book a holiday on the system, the database should check whether is available on the following conditions:
Below is the schema for the fields involved in the valiation:
There cannot be more than 2 agents on "Annual Leave" as leave_type off per team (Department: "One").
If they have exceeded there "TotalHoursLeft" then warn the user that the agent has no more allocated holiday
if there are more than 4 people off per system, then warn user that user cannot book (although this can be overidden).
Can any one please give me any ideas on how to do this?
Thank You.
M
________
red head Webcam
Last edited:
