Many to many self-relationship

[bxm]

Hi,

I have a file of clients, some of which are related. For example client 123, 234 and 345 are all related to each other.

I want to set up a display of related clients so that if I enter 234 and 345 as related clients to 123, then I will have 123 and 345 showing as the related clients of 234, and have 123 and 234 showing as the related clients of 345.

I am guessing this requires a self-relationship and a portal, but I'm not sure how to set it up.

Suggestions?

[Ender]

Welcome bxm,

You might see if this thread about the same sort of structure helps:

http://fmforums.com/forum/showtopic.php?tid/171427

As you'll see, there were a few different approaches, including the self-join with a multi-key. Personally, I still prefer the two join records.