Updating inventory count
I want to be able to have a table with an inventory of vehicles, vehicle numbers and the quantity available to be assigned to a job. In another table I have related those fields to an assignment table...
Forum Discussion
Hi Montgomery,
In the inventory table have you created any summary fields that would allow you to summarize up the number of vehicles being used from the assignments table in order to compare your total quantity to the assignments? Depending on if vehicles get checked back in you may also need to find a way to summarize up only those assignments that are current and would effect the pool of vehicles currently available.
In the inventory table have you created any summary fields that would allow you to summarize up the number of vehicles being used from the assignments table in order to compare your total quantity to the assignments? Depending on if vehicles get checked back in you may also need to find a way to summarize up only those assignments that are current and would effect the pool of vehicles currently available.