Field in table that is latest record in another table

[tagteam]

Is there a way to create a field in table 1 that is the latest record in table 2? I have a car database that tracks car information in table 1 and tracks leases in table 2. I would like to add about 5 fields to table 1 from table 2 to but I want those field to be the latest lease record information for that car.



The main reason I am doing this is I would like to be able to use the filter to find all the cars with leases expiring this year so i need to be able to use the value in a filter and if that wont work then it will be kind of pointless for me.
Thanks

[June7]

Not a good idea. Use query to retrieve the 'latest' date record. Review: http://allenbrowne.com/subquery-01.html#TopN