Can I retrieve a value in a relation based on a sort?


Is it possible to do a lookup or find a record value based on a sort in a sub table.

Table A: Companies, idCompanies

Table B: fk_idCompanies, date of investment, valuation.

I want to show the latest valuation in my company record view. I am already showing a list, so want to create a lookup or calculation based on the last record by date of investment in my sub table.

? Is this possible?

On top of the relation, you can use a single value column to retrieve the last value of a column found through that relation.


Star!! Thanks

1 Like