Jump to content
Sign in to follow this  
Andrew C

Many to Many Relationship to Show Unrelated Items

Recommended Posts

I'm having trouble creating a relationship that seems like it should be pretty straight forward.

Here is what I'm trying to accomplish:

Table A and Table B have a many to many relationship. I have a layout based on Table A and would like to have a portal that shows all of the items on Table B EXCEPT the Table B items that are related to the current record in Table A.

Here's what I have now:

Table A related to Join Table via relationship 1 = 1 (calculation fields) AND Table A primary key does not equal Join Table foreign key A.

Table B related to Join Table via relationship Table B primary key = Join Table foreign key B.

The portal showing related records from Join Table gets me the right number of items in the list but they are not labeled correctly.

I've also tried a lot of different relationships and using the other table for showing related records but haven't been able to figure this one out yet. Any advice greatly appreciated!

Just let me know if it would help to explain this in less abstract terms.

Share this post


Link to post
Share on other sites

let me know if it would help to explain this in less abstract terms.

It certainly would. Still, I think you'll find the answer here:

http://fmforums.com/forum/showpost.php?post/233897/

See also an important note here:

http://fmforums.com/forum/showpost.php?post/274656/

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Will Xu 
×

Important Information

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