Max value of ref rows

[dpavlov]

Hello,

i have a table with CARS where Car number is key and a table with Mileage with ref to CARs

Struggling to get the MAX mileage for every car in the CARs table from the rows referenced in Mileage

[Suvrutt_Gurjar]

Assuming [Mileage] column in the child “Mileage” table is a number or decimal type column, please try in the CARS table an expression in a VC of

MAX([Related Mileages][Mileage])

Where [Related Mileages] is the system generated reverse reference column in the CARS table and [Mileage] is the number or decimal type column in the child table.

[sreekar_pranav]

You can use Select() to get data from Child Table to Parent table