AnsweredAssumed Answered

Struggling To Make A Relationship Work

Question asked by poliver88 on Jan 25, 2019
Latest reply on Jan 25, 2019 by comment

I have two layouts - Contacts and Companies (using same name tables)

 

On both of these layouts there's a portal where you can view/create records from another table called Credentials

 

There's a relationship between
Contacts::ContactID    - Credentials::ContactID           and
Companies::CompanyID - Credentials::CompanyID

 

So on Contacts layout i can view Credentials that have a ContactID and
on Companies layout I can view Credentials that have a CompanyID

 

Problem arises on Companies layout as I don't want to view only the records that have CompanyID to them
I would also like to view records with ContactID but only if they have CompanyID attached to them in the Contacts table

 

I tried to create a relationship with a calculated field on the Credentials table that didn't seem to work :/

Attachments

Outcomes