Many to Many Relationship to Show Unrelated Items

[Andrew C]

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.

[comment]

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/