Hello.
I've decided to get organized, and create a database of all the belongings in my home, for both me and my partner. I might as well do something useful during lockdown! I've got one question though.
I plan to create a table that lists all the rooms in the house. Then I'd also like to list all the locations within those rooms (say top draw, box under bed etc). I might be over thinking this, but do I need to create the locations in the room as a sub table to the room itself (is that even possible?)? I'm just struggling to get my head around it at the moment.
Many thanks for your help.