The Airtable table I tried to share in the following thread is not correctly displayed.
Track Room Items Base design
I want to track what items are in which room. What is the ideal solution for this? For now, I am not interested in the quantity, but only that a certain item exists in a room or not. For the items exist unique categories, namely furniture, tool and machine.
This is what I have created so far, two tables ‘Room’ and ‘Interior’:
Currently, I do not have a junction table. I created three columns in the ‘Room’ table based on the unique categories and linked it to the ‘Interior’ table. I restricte…
... View more