Calculated column based on two related columns

Hey guys!

I need to determine the max value for a specific case.

I have a simple sales table that contains some basic information per order with these columns:

• Order-Nr (Key column)
• Step Name
• Value

This table contains 1 row per order

Then I have a second table that is linked to this table using the Order-Nr and contains some more information:

• Order-Nr
• Step Name
• Status

This table shows me the routing per order and contains several rows per order.

Now I would like to add a calculated column into the first table that contains the Max Status for each order and the corresponding step name. The first table already has the latest Step name per Order. I just need to add the latest Status for the order and the latest Step Name