Hi @Jacob_Conell, my guess is that new checks are entered via form or similar into the truck checks table?
If it’s a new record you’re taking the mileage info from, I would use that as a trigger. So run an automation where the trigger is “when record created”. Part of data that’s passed there should be the linked truck, so you can use a “find record” action to pull that record from the trucks table. Then you’ll use an “update record” action to update that truck record with the mileage info from the triggering record.
Let me know if that makes sense!