Example: Prevent overlapping date ranges

This example displays how to prevent date range overlap on a booking of property. The Bookings table comprises validation rules that do not allow saving a new record if a property name matches and a date range is within or crosses an existing one.
Example: Prevent overlapping date ranges Database Illustration


How the example works:

  1. The Bookings table refers to itself via 4 separate Many-to-Many relations.
  2. Each relation has different match conditions that define a case of overlapping.
  3. Moreover, every relation includes a summary column. Such summary columns calculate number of records with corresponding overlapping.
  4. Also, the Bookings table comprises the validation rule which does not allow saving a new record, if any summary column has a value that is greater than 0.

To help you make the system work for your needs, we have developed the following service program:

  • Discuss your needs with our staff.
  • We’ll determine and confirm the workflow logic of your database.
  • We’ll create a ready-to-use database to fit your exact business model.
  • You’ll get a solution designed especially for your needs.

Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.

We offer free system configuration assistance
(up to 4 hours of consulting work).

If you decide that our database is not exactly what you need - you owe nothing.
Like what you see? Try Example: Prevent overlapping date ranges Database today!