Its a bit hard to provide definitive advice because you haven’t explained how you have things currently set up.
I think what you might be struggling with is how to use CONNECTIONS to achieve this.
I assume that you are managing rooms for a range of companies, and the heirarchy is something like:
COMPANY —> PROPERTY(s) ----> ROOM(s).
And that each property has an address and other details.
And that each room has a range of details as well as a status of free, taken or not available.
To set up that sort of relationship, I would set up 3 connected tables.
COMPANY - which has the details of the COMPANIES
PROPERTY - which has the details of all the PROPERTIES, and a CONNECTION to COMPANY they belong to (Each property connects to one company, each company connects to many properties)
ROOMS - which has the details of each room, their status, and a CONNECTION to PROPERTY it is part of (Each room connects to 1 property, each property connects to many rooms)
Then you can show a grid list of companies, with a link to view company details.
On that details view, add a grid view of:
Then your “COMPANY DETAILS” view would be something like:
If you want a list of ALL vacant rooms, then create a grid view of ROOMs, filtered by available, and add the property and company details to the grid as connected fields. Would look something like this:
Reach out if you need more details or advice.
P.S. Just reread the original question - if using availability dates you can achieve this by using appropriate date filtering on the views - a bit trickier but the basics remain the same.
