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?