I hope this is the correct section for my question.
I have a database with 3 tables.
Once a table for vehicles. A table for drivers.
And thirdly, a table in which I enter the date on which a new driver enters a vehicle - or a vehicle is turned off / parked.
Now I would like to always have the name of the driver displayed in the Vehicles table, who took over the vehicle last (seen back from $today) - or it should be displayed that the vehicle is turned off / parked. In both cases, the date of the last vehicle pick-up / the last time the vehicle was parked should be displayed.
It looks like you record a date on the third table and you could use that date to sort or filter by. You could also use the “Created time” or “Last modified time” field types. These auto populate, either when the record was created for “Created time” or when its updated for “Last modified time”. These fields format as dates that you could sort and filter by.