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?

Thanks,

Ted Z.

(1) Answer

Login