Portal based on relationship
Posted on 2006-06-14
I'm working with a portal and am having trouble getting the right information in it.
I have contacts that I'm keeping track of along with their spouse and children. In the Contacts table, there is a ContactID assigned to each record along with an auth_ContactID. The contactID is unique to all records, but the auth_ContactID will reflect the head of the family (HEAD) and so all family members (DEPENDANTS) will have the same auth_ContactID (the HEAD will have the same number for both their ContactID and auth_ContactID).
I've tried creating the portal based on a table occurance Contacts_Related that is based on the Contacts table with the relationship:
Contacts::ContactID = Contacts_Related::auth_ContactID. (The portal won't popluate)
The portal is on a layout based on the Contact table and ideally, I would like it to populate with all the DEPENDANTS of the HEAD contacts.
This isn't working. The only way that I can get the portal to populate at all is by making the relationship based on:
Contacts::auth_ContactID = Contacts_Related::ContactID (The portal populates with the HEADS's data in the DEPENDENTS's Contact record, but not the other way around)
Contacts::ContactID = Contacts_Related::ContactID (the portal populates with the Contacts own record and no one