AnsweredAssumed Answered

connection to more than 2 periods

Question asked by magamy on May 3, 2017
Latest reply on May 8, 2017 by user19752

I'm creating database for travel agency, when the sales agent chose the hotel they chose also the check in and check out date.

23456.JPG

in the back office the hotel rates are entered and each hotel has different periods with different rates.

123456.JPG

i was able to get the rate when the check in and check out is falling in 2 periods by relating the check-in date the table and relating the check-out date to the table occurrence

3456.JPG 

456.JPG

 

 

>>>> but faced a problem when its falling into 3 periods like the in the first and second pics above

and if its more than 3.

hope you can help solving this problem.

 

this is my first post and i wanna thank everyone here as this website has been one of my best references.

Outcomes