Solved: How to do virtual column from a related column - Page 2

111139 · 02-13-2021 02:53 AM

Hi
I am trying to make an app for my organization property control and inspection

I make two table 1. Property table 2. Inspection
The Inspection table has id ref. To the Property table and content a Status column of each inspection

How can i put a virtual column in the Property table to select and display the latest update status from the [Related Inspection column] at the end of the property table

Thank you very very much

Steve

Try:

ANY(
  ORDERBY(
    [Related Inspections],
    [_ROWNUMBER],
      TRUE
  )
)

View solution in original post