Get a related field

[Coriolan_66]

Considerer a gymn class

Student::

::ID

::Name

::age

::gender

::Biggest_value (Calculation)

::Biggest_value_date (Calculation)

::Biggest_value_place (Calculation)

and

Records::

::ID

::StudentID

::place

::date

::value

Ofcourse I can pick Biggest_value using the Max function. I have no clue how to get ::Biggest_value_date. This is improtant to me to know the highest mark of that student, but also where and when he achieved it. Thanks you for your support.

[comment]

This is improtant to me to know the highest mark of that student, but also where and when he achieved it.

For what purpose? If it's just to show them on the layout, you can use another portal. Make it one row tall, and sort it by mark, descending. If it's for something else, you will need another relationship - or a rather complex calculation.

Note also that more that one mark can be at maximum value - you need to consider what you want in such case.

[Matthew F]

I agree that you might just want to have a portal (with one or more fields) that is sorted by 'value'.

However, if you really want to show the date associated with the maximum value as a calculation, you could create a special relationship for this purpose.... Create another instance of the 'Records' table (call it MaxRec) in your relationship graph. Create a relationship with the Student table such that (Student::ID = MaxRec::StudentID AND Student::Biggest_value = MaxRec::value). Then the calculation for Biggest_value_date in the Student table is simply MaxRec::Date.

[Coriolan_66]

Thank you for both valuable support. I'll try these two approaches.