AnsweredAssumed Answered

Validate requested bookings

Question asked by PecCars on Apr 17, 2017
Latest reply on Apr 17, 2017 by beverly

Hi everyone,


I have an app where I record requests for bookings. I need to be able to check if a requested date is already booked. I have read a bit in the community and found that this could be done with self join relationships.


From a technical perspective I have a table called Requests with the following fields:

- ExpectedArrival

- ExpectedDeparture

- Arrival

- Departure


Booked entries are the records in the same table that have entries in Arrival and Departure.


So, if I resolve this via self join relationships I would need somehow to have any existing Arrival or Departure to be within the ExpectedArrival and the ExpectedDeparture.


Any suggestions how should I do this ?


philmodjunk ?