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 ?

Outcomes