I want to create a new record in a table (table X) on click of save.
There are few checks that need to be in place before allowing the creation of new record in table X:
Check1: if the service selected on the current record (table Y) is already existed in table X
IF yes,
Check 2: Look for the start and the end time of the service being in used in table X.
If it is different from the start and the end time requested in the current record (table Y), then allow the creation of the record. Otherwise, stop creating it.
Can someone help with the date and time logic check ?
