Mark Appleby Posted July 31, 2002 Share Posted July 31, 2002 This should be very easy to understand. I have 2 databases, One is family and it is related to many family members, by a family ID. In the family member file I want to be able to see all relations i.e. members of the same family. I have self join relationship for the family members based on the family ID field. My problem is that in the portal I keep getting two people of the same name even though I have only one of each, I can not see the other people in the family that I want to see. EG family name Murphy members of family John and Margaret. If I go into Margarets record, In the Relations portal I see margaret twice but can not see John. Link to comment Share on other sites More sharing options...
LiveOak Posted July 31, 2002 Share Posted July 31, 2002 The only thing I can think of is to make sure the fields placed in the portal are from the relationship (i.e. "SelfRelationship::Family Name" and NOT just "Family Name". -bd Link to comment Share on other sites More sharing options...
Mark Appleby Posted July 31, 2002 Author Share Posted July 31, 2002 You got it! I had the field full name in the portal rather than the field from the relationship. Simple mistake! Thanks for your help. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7930 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