bxm Posted March 14, 2006 Share Posted March 14, 2006 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 More sharing options...
Ender Posted March 14, 2006 Share Posted March 14, 2006 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 More sharing options...
Recommended Posts
This topic is 6611 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 accountSign in
Already have an account? Sign in here.
Sign In Now