If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|