Pulling data from certain record

[KYC]

Have a file with daily entries of odometer readings for over a hundred delivery trucks. When the client makes a new record in that file, and enters the truck number, would like to have the last odometer reading for that truck number be automatically inserted in the new record. Can

[Ocean West]

Moving to different forum...

Create a file of all trucks... Then another file for odometer readings.

via portal can see all readings for that truck. when you create a new reading you can use the Max of function to get the last reading.