Data set up question

1358 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!

0 Replies 0