I am a novice at Access and I have built a maintenance database. I have a Repair Record table and a Equipment id table.
I have placed a sub form for the Repair Record Table on the main form. When a service to a piece of equipment is completed the mechanic
will enter that in the Repair Record sub form. When he enters the word "service" in the Parts No. field and the Mileage in the Hours/Mileage field
I would like for that number to show in the Truck Last Serviced field. So the word service in one field would key the mileage in another field to be shown in
a field on a different table. Any help with this is appreciated.