Hello,

I am developing a database for my uncle to allow him to create auto repair work order/invoices for his customers. The problem I am facing is that I am not sure on how to go about a solution to update a customer's odometer reading for every event that a particular vehicle needs servicing.

I have made a table based on the customer's vehicle information that contains the fields "VehicleID", "CustomerID", "LicensePlate", "Year", "Make", "Model", "Odometer", and "VIN". The issue here is the odometer reading will be different every time a customer would bring their vehicle in for service and need some suggestions on a user friendly method to allow my uncle to update an odometer reading a specific work order without effecting every work order associated with a particular vehicle. The Odometer field needs to reflect change based on work order, not change the initial information stored in the vehicle info table/form.

Any suggestions?

Charles Gomez

---

Reply from Alex Hedley:

You'll want another Table just to store the Odometer.
Have that linked to a VehicleID and add a SubForm onto your VehicleF.
You can then add as many as you need per vehicle.

It's a bit like the Notes example for each Customer.