Cross Referencing

#1

TABLE SUMMARY
Table 4- ML Call Center
“Logo”, “Call Center #”, “Notification Mailbox” fields: Non-primary single-data fields

Table 10- Direct Bill Directory
“ML Call Centers” field: Non-primary multi-data field linked to primary field in table 4

Table 13- Customer Information
“Policy Name” field: Non-primary single-data field linked to primary field in table 10

WHAT I WANT TO DO:
Create fields in the Customer Information Table for “Logo”, “Call Center #”, “Notification Mailbox”.
Data has to pull from Table 4 by cross referencing the Table 13 Policy Name field to the Table 10: ML Call Centers field to the Logo Phone # and Email fields in Table 4. Note not all fields are primary fields. I do not see a way to do this with the link or lookup functions.

0 Likes