Jump to content

Many to many self-relationship


bxm
 Share

This topic is 5738 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5738 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.