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!