How do I reference a second data table when creating a calculated column?

I have two data tables:

SF 1Line (list of property identification records)

SF.Monthly (monthly oil and gas production by property)


Tried this in "Insert Calculated Column":

If([SF 1Line].[PRODID]=[PRODID],[SF 1Line].[ClusterID],"")

(but it doesn't recognize other table.)


Is it even possible to reference a second data table in these custom expressions?


Ted Z.

(1) Answer