I have 3 files (hierarchies, Companies - subset of Hierarchies and contacts - subset of Companies) I would like to display the Key Contacts which are identified in the Contacts file. I created a calc in contacts which shows the record ID for only those records that hold the key contact identifier. After creating a relationship in the Companies file (Co_ID and Key Calc) I am able to display a portal in the Companies File showing the Key Contacts for that Company. In the Hierarchies file, my layout has a portal showing all of the Company locations

I would like to now display those same contacts in the Hierarchies file (Hierarchies file shows multiple locations of the same company) and I can't seem to do that.

thank you for any assistance you can offer.

Do you mean files or tables?

Is the attached any help?

For some reason - probably my fault - the file didn't attach to the previous post

hierarchy.zip

Sorry, I've just noticed you're on version 5 ...