View Single Post
  #1  
Old March 25th, 2010, 04:31 AM posted to microsoft.public.access.tablesdbdesign
ginge
external usenet poster
 
Posts: 3
Default Database to track inventory in company cars

I have built a database for my company (a small electrical contracting firm)
using various access 2007 templates. At the moment it contains customer
contact details, employee details, a tendering/job pipeline tracking leads
and jobs won, a warehouse register tracking our tools in/outs and a vehicle
details which tracks the expenses on our company cars. I want to add to the
vehicles portion a way to track the materials in each car so that we know
when to reorder stock. Each van contains the same stock/amounts but I want to
be able to generate orders for each van when stock reaches a min. level for
that particular car. I was thinking a table of inventory but im not sure how
to allocate it to each car with their own min/max system (maybe a stock
location table??). Not sure what transaction tables/queries would be needed
to perform this task.

Any help would be greatly appreciated