Qrew LegendWelcome to the Community Forum, we are very friendly here.
I suggest that you have a table of trucks and a relationship where 1 truck has many mileage updates.
Then a field in the trucks for the date of the most recent completed service and typically a truck would also have the mileage at that service, just as an aside, typically you will want a service history table with the date and the mileage of the service and the type of service and comments. You can get the date of the most recent service and the mileage of the most recent service using a summary maximums on the relationship where one truck has many service histories.
OK, now back to your question. Your truck knows the mileage of the most recent service, and it knows the current mileage. So if you subtract, you know the mileage since the last service. If that is above a threshold like 10,000 then it's due for service.
Feel free to post back with any questions.
I am going through this now, thank you. I will see if I can figure it out. Newbie here
Qrew LegendIf you are creating a table for Trucks, you will need to set the KEY field to be the same field that the truck is identified with in the mileage data feed, so they will link up automatically in the relationship.
