Relationship between two fields, switching lists from one to another
I'd love to find a better description - words fail me today...:)
I have two fields in an Organisation table (::ORG)
<<Parent>> is the parent company of <<Brand>>. There is a SN to each record, and the relationship between <<Brand>> and <<Parent>> is flat, within the ::ORG table.
I want to be able to list all the <<Brand>>'s that fall under a <<Parent>> name. eg.
Diageo makes Guinness, Smirnoff, Interslate and Johnnie Walker.
My thought was to create a self-join, and in a new layout under the new sj_ORG, do a portal linking back to the original ORG table.
<<Parent>> is within sj table
<<Brand>> is within ::ORG table
But, this didn't really work.
I do want to show these as a portal in one table or another. It is so I can put it in a report.
So my thinking is probably off a little or not onto it.