I am setting up a reservation system to reserve equipment, and the reservations are made for a date range specified by the user.
How do I check to make sure that there isn't already a reservation for that equipment that overlaps with the dates of the requested reservation?
Note: I'm new to this, so don't hesitate to bombard me with details. I have Object types setup for Equipment and for Reservation, and I have them connected. I also have the Reservation connected to a User Role to keep track of who the Reservation is for.