March 14, 200619 yr 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?
March 14, 200619 yr 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.
Create an account or sign in to comment