I've got a table called "Beings" that includes both people and organizations, each with a unique sequence number called "BeSeq".
I've got another table called "BBLinx" that contains 4 fields of significance:
• BBLSeq, the unique sequence number for each "BBLinx" record
• BeSeq A, the code that matches Being A in "Beings"
• BeSeq B, the code that matches Being B in "Beings"
Thus, to show that Lynn Lewis (BeSeq 1234) is the choir director at 1st Baptist Church (BeSeq 1235), there would be a record in "BBLinx" (let's say BBLSeq 101) containing the values 1234, 1235, and "choir director", respectively. Similarly, to show that Lynn is married to Kim Smith (BeSeq 1236), I'd have a "BBLinx" record (BBLSeq 102) containing the values 1236, 1234, and "spouse", respectively.
Notice that BBLSeq 102 has Lynn under BeSeq B, whereas BBLSeq 101 had Lynn under BeSeq A. This is a consequence of the way "BBLinx" records are created, since the "Beings" record from which I begin always goes into BeSeq A, while the one I'm clicking on in the picker portal always goes into BeSeq B. Nonetheless, it's possible for Lynn's "Beings" record to have a portal showing ALL the records in "BBLinx" to which Lynn is connected, whether via BeSeq A or BeSeq B.
My current frustration is that the only way I've been able to display this portal within Lynn's "Beings" record is to show ALL the data it's linked to:
• 101, showing Lynn, the church, and "choir director"
• 102, showing Kim, Lynn, and "spouse"
Well, I don't really NEED to see the info for Lynn in the portal, since I'm looking straight at much more detail in the "Beings" record itself. All I really need to see are:
• 101, church and "choir director"
• 102, Kim and "spouse"
Similarly, from Kim's record, what I want to be able to see in the portal is:
• 102, Lynn and "spouse"
In short, I want to be able to filter out the redundant parent-record data from the child portal. But I'm danged if I can figure out how to do it. Any ideas?
For extra credit, I want to be able to sort the portal on the non-parent-record being.