AnsweredAssumed Answered

Last(field) filter question

Question asked by JammieSchmunk on Jul 29, 2018
Latest reply on Aug 1, 2018 by philmodjunk

I have two tables:

Assets

Employees

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

Outcomes