Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Let user know if they are trying to schedule an event where the client is already scheduled

I have a form with a ClientID and a ScheduleDate and an InTime and an OutTime.  If the user tries to add a record where the ClientID, ScheduleDate, and the InTime and an OutTime already exist, provide a message box.

In other words if the client being scheduled is ClientID 4 and the ScheduleDate is 7/31/2021, and the event is being scheduled between the InTime and the OutTime, present the warning.
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial