6 Replies Latest reply on May 8, 2017 1:27 AM by user19752

    connection to more than 2 periods

    magamy

      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.