# Haven an ITEMS table and consult it from other table **URL:** \ **Category:** Ask for Help\ **Created:** [March 27, 2024, 6:31pm UTC](https://community.glideapps.com/t/haven-an-items-table-and-consult-it-from-other-table/72103 "2024-03-27T18:31:41Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![22\_DG](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/22_dg/32/72893_2.png) [@22\_DG](https://community.glideapps.com/u/22_DG)\ **Post date:** [March 27, 2024, 6:31pm UTC](https://community.glideapps.com/t/haven-an-items-table-and-consult-it-from-other-table/72103/1 "2024-03-27T18:31:42Z")
Hi I am building an inventory control app on glide, the main objective is to control inventory items of the different appartments each time it changes tennant. So the idea is to have a homepage with the APPARTMENTS, and once I enter to certain appartment I can see the list of items on that appartment and check if something’s missing. If there is, I input that I have 10 forks instead of 11 and a nice RESTOCK alert stores on that table. All that, I accomplished for 1 appartment… I am having lots of trouble trying to build the right table architecture for making it dynamic with other appartments. So the ideal thing would be to have a master ITEMS table where I list all the possible items I can find on an apparment. But not every appartment will have all of this items and not the same quantities So next what I would love to accomplish, is create the APPARTMENT 1 THINGS table that brings all the items on the master ITEMS table but I can continue and add columns as BOOLEAN to put it ON/OFF if the item is in that appartment and the QUANTITY of that particular item So, in the future, if I edit the ITEM name from the master table, all the appartments will be updated, but at the same time I can have different items in APT 1 than APT 2 as well as quantities Is there a way to accomplish something similar to this? Thanks AA