Solved: formula (Max) - Page 2

Yokuinin · 03-13-2022 06:57 PM

I would like to get the data from the child table.

Parent ... Order table

Child ... Detail table

Here is the process what I would like to do.

1. "ID_order" input in the Parent table.

2. "ID_detail" input based on the Parent and input the detail.

3. Return the record to the Parent table.

There are 3 kinds of data I want to have.

1st ; The biggest number among the same ID_order

2nd ; The latest date among the same ID_Order

3rd ; The biggest number of Row among the same ID_order

How should I describe the formula?

Can I get the record in the Parent?

Attached images are my ideal target.

Suvrutt_Gurjar

You will have a virtual column called something like [Related Details] in the parent Order table.

You could create three VCs with expressions something like

1st ; The biggest number among the same ID_order

MAX([Related Details][Size])

2nd ; The latest date among the same ID_Order

MAX([Related Details][Delivery Date])

3rd ; The biggest number of Row among the same ID_order

MAX([Related Details][_ROWNUMBER])

If you wish to have these columns values stored in real columns in the parent table, please evaluate reference actions.