Hello - I am building a hotel booking application that will need to search my Airtable database for rates based on a date. Right now I have tables for:

Resort which has multiple

Properties which has multiple

Rooms which has multiple

Rates based on a date constraint

How do I structure my data to make it easy/possible for my application to perform:

Find rates between Date 1 and Date 2 for all rooms, in all properties, at Resort A

I don’t think the way I have everything structured in the tables above is working, because I can’t easily cross reference dates, rates, and rooms.

Thank you for the help!