Expression condition to include field from a different table

[MauriceWhelan]

Hi. I have the following expression as an initial value to pull the MAX time that exists in the table. MAX(SELECT(Works_Orders_Master[Production Finish Time],[Date of Production]=[_THISROW].[Date of Production])

Is there anyway that I can incorporate fields called [Department] & [Area] from an associated table called (Routings_Master) - associated through [Record ID] as Ref type.

Something like
MAX(SELECT(Works_Orders_Master[Production Finish Time],AND([Date of Production]=[_THISROW].[Date of Production],
Routings_Master[Department]=[_THISROW].[Department],Routings_Master[Area]=[_THISROW].[Area])))

Hope that makes sense.

Many thanks.

Maurice.

[Steve]

If the Record ID column is a column in the Work_Orders_Master table:

MAX(
  SELECT(
    Works_Orders_Master[Production Finish Time],
    AND(
      [Date of Production]=[_THISROW].[Date of Production],
      [Record ID].[Department]=[_THISROW].[Department],
      [Record ID].[Area]=[_THISROW].[Area]
    )
  )
)

See also:

help.appsheet.com

Dereference Expressions

Use a dereference expression to retrieve a field value from a referenced record.

[MauriceWhelan]

Thank you so much @Steve