AnsweredAssumed Answered

Relationship between two fields, switching lists from one to another

Question asked by happyez on May 27, 2011
Latest reply on May 28, 2011 by happyez

Title

Relationship between two fields, switching lists from one to another

Post

I'd love to find a better description - words fail me today...:)

I have two fields in an Organisation table (::ORG)

i. <<Brand>>

ii. <<Parent>>

<<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.

Any thoughts?

Outcomes