AnsweredAssumed Answered

Correct relationship for calc field (Lookup function)

Question asked by dnechytailo on Oct 21, 2015
Latest reply on Oct 21, 2015 by dnechytailo

Dear all!


I have 2 tables: Companies and Ownership.

The first contains fields: Comp_Code ... Country ... etc.

The second contains: Comp_Code, Mother_Company ... Country. First 2 fields lookup company names from the first table (Companies). Country field in the second table is calc field and must lookup country name for Mother_Company based on Country assigned to a company in the 1st table.

Can you advise on correct relationship between both tables and proper Lookup function script for my calc field?

Thank you.


Example below:


Table 1: Companies

Comp_Code  … Country  …

AAA                          USA …

BBB               …       USA …

CCC               …      CAN …

DDD               …      CAN …


Table 2: Ownership

Comp_Code  Mother_Company  Country*

AAA                         BBB                USA

BBB                         CCC               USA

BBB                         DDD               CAN


Layout: Ownership


Company:                 BBB


Mother companies:

                                 CCC USA

                                 DDD CAN



* - calc field using Lookup function