X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Home Inventory With Complex Location Descriptions, Access 2013    
post Jan 8 2019, 10:11 PM

Posts: 111
Joined: 29-March 06
From: Colorado

I am starting to design an home inventory db and need some guidance. I want to track the location of home inventory items in the common way (such as items in the living room or items in the master bedroom, etc.) For this the logic seems simple enough. But I also want to extend the granularity of the location description for some rooms of my home. For example, I have a cabinet of drawers in my garage that has 32 drawers. For this I'd want to define the location of an item in one of the drawers (say a specific wrench) as 'in the garage and in drawer 24 of the white drawer cabinet. Because I have other locations in the garage that have multiple sublocations I have a need for several muli-level location description. For this, I see a need for several "one to many" table relationships. While this also seem logical, what doesn't seem obvious is the forms needed to enter an item in its proper place. For a one level location description the form would be simple - drop down to enter the room of the house and I'm done. But the form for the multi-level items is less obvious particularly if I'll have two level items, three level items and maybe four level items. I was hoping to get some insight on how to structure the tables and forms to handle this. Or am I looking at this completely wrong? Thanks in advance.
Go to the top of the page
post Jan 11 2019, 09:47 AM

Posts: 1,489
Joined: 7-April 10
From: Detroit, MI

To do this, you are going to need to use subforms that show the levels. The wrench is an example of Main Form containing the wrench information, one subform contains room location (garage), second subform contains cabinet, dresser, shelf, etc., and the last, the particular drawer it is located in. You will have to think this through as to how many sub details are needed for any particular item

Remember ... Armstrong, Aldrin and Collins flew to the moon and back with a computer system less complex than a modern, programmable toaster ...
Go to the top of the page
post Jan 11 2019, 09:05 PM

Posts: 22
Joined: 2-July 10

I think you can use the attached database and in the Purchase Register > Material Register you can register all the materials for the inventory and in the location field you can enter the location

and for your item 'in the garage and in drawer 24 of the white drawer cabinet" you can enter the location as GWD24 which will mean Garage > White Drawer > Drawer 24.
This post has been edited by Junaid: Jan 11 2019, 09:24 PM
Attached File(s)
Attached File  ShopbooK.zip ( 1.44MB )Number of downloads: 1

Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    16th January 2019 - 03:50 PM