Jump to content

Many to many self join question


Darryl W
 Share

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

Recommended Posts

Hi Friends,

I have a layout based on a person table. I would like to connect 2 people together based on a relationship like friend, wife etc. Because each person can have many relationships, I created a join table and linked it to another table occurrence of the person table.

My problem is choosing the second person on my layout. I can enter the type of relationship (saved in the join table) but can't choose or type in a person reaching through that relationship.

Can someone help me with an easy solution that I just can't see? or do I have to do it with a script?

Thanks so much.

[email protected]

Many_Self_Join.jpg

PersonJoinTest.fp7.zip

Link to comment
Share on other sites

Hi again,

I'm going to give this another try, because I really need help on this one. I changed the layout and portal somewhat and it works, BUT... I need to get rid of the serial numbers in the drop down list in the portal. If I do a "show only second field" or "sort by second field" in the value list, it doesn't work.

Here's the new file...

Please help!

Thanks in advance.

[email protected]

PersonJoinTest2.fp7.zip

Link to comment
Share on other sites

This topic is 5600 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.