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?