Best table setup for our construction inventory tracking?

[quarky2001]

We own an ever-growing business, with a number of tools as assets (which are serialized), and more which are simply multiples of identical items. These tools and materials travel from jobsite to jobsite, we need a better way of keeping track of them.



What would the best approach be?
Right now, I have a single table containing records for each serialized tool (haven't figured out multiple identical items yet), and each tool simply has a field labeled "Location". Then it's basically find and replace to change the item's location, but that is very cumbersome.

My main curiosity is just how the tables should be set up, since I know that can make or break a database design.

[June7]

So tools are assigned to employee (or jobsite) - like checking out book at a library. Might explore MS Lending Library database template for ideas.

[CJ_London]

is this a continuation of this thread? Or a new question?
https://www.accessforums.net/showthread.php?t=79130

[Mickjav]

You could assign them to a vehical so when you stock take a vehicle you also have a list of tools test equipment Etc.

I never covered assigning tools to individual employees in my Works Manager Maybe I'll have to revisit that in an update.

mick

Edit: http://www.databaseanswers.org/data_models/