I have two tables:
I have transactions in Assets that "assign" the asset to a Employee. On the Employee table I just want the asset to show up if only it was the Last date of service transaction. I need to know who has the asset (only one person can have the asset).
I tried the Last(asset:date_of_service) but it still shows in all the previous employees