I have a building having 2 floors. Where there are 10 rooms. I want to build a database where I have
- List of Items Category: Flooring,Wall & Column,Ceiling,Glazing,Door and Window
- List of Rooms: R1 to R10
- List of Items: 20 Items (say) where Items are not unique to each room. Each item has their item description and picture.
I want to search room by floor, and it should get me all the relevant details for each room by item categoy.