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.
Can someone help me to realize this?
Many Thanks !!