Validating Schedule Times
This forum has given me a ton of great advice in the past... hoping for a little bit more!
I'm adding a section to an existing database that includes scheduling for our deliveries. The design has been relatively simple, but I can't think of a way to Validate the entries in a way that times are "blocked" such that you can't accidentally double-book a spot of time.
End Time (calc: Departure Time + Time Blocked)
Basically, if I schedule a delivery at 8am with 30 minutes blocked for it, the next availble time would be 8:30. I want to generate an error if someone tries to schedule a delivery between 8 and 8:30 or schedules a delivery with an end time between 8 and 8:30. This strikes me as needing some clever math more than anything.
The database is already script heavy so it really doesn't matter whether this uses field validation or is scripted out. I'm open to any and all ideas.
Thanks in advance!