AnsweredAssumed Answered

Multiple Relationships Between Tables

Question asked by lxr_david on Feb 20, 2018
Latest reply on Feb 20, 2018 by philmodjunk

I am having trouble setting up Portal B as defined below. Does anyone have any ideas regarding how to setup the secondary relationships and portal?

 

I am editing an existing DB that has 2 tables-

Table 1 : Companies

Table 2: Contacts

 

I want to setup 2 portal fields in Table 1. Each Portal should display 3 fields from related Contact records in Table 2.

 

Portal A should display 3 fields from related Contact records from Table 2 who are employees of a Company listed in Table 1.

 

Portal B should display 3 fields from related Contact records from Table 2 who are not employees of a Company listed in Table 1.

 

A Contact record in Table 2 should have input fields to allow the Contact record to be related to up to 4 different Company records in Table 1. For Example:

Related Company 1 Field: Contact’s Employer

Related Company 2 Field: Optional, related Company 2

Related Company 3 Field: Optional, related Company 3

Related Company 4 Field: Optional, related Company 4

The DB already has Portal A setup and it functions properly. I can provide the calcs used in this if it would be helpful.

Outcomes