Double booking alert
I am trying to figure out a way to have an alert pop up if an employee gets book twice in a day.
On the confirmed events table I pick an employee from a pop-up list (being pull from employee records), each confirm event is one unique record. i am trying to figure out a way to let me know if the employee gets double book on the same date (it can be in a different record).
Attached is the relation ship map.