Unexpected Results in NEQ relationship

[Jim Lah]

I am struggling using the not equal to (NEQ) relationship between tables. I have a simple 3 table database (attached).

Forum - a list of forum which members may join

Participant - a join table, showing which Members have joined which Forum - Forum may contain multiple members, Members may join multiple forum.

Member - a list of all the Members.

I wish to show a layout for each forum which lists in one portal those members in that forum, and in another forum the balance of members (the pool) that have not joined this particular forum.

I thought the latter portal would be an easy application of the NEQ relationship - but the results are unexpected. If a forum has only one member, then that member is correctly removed from the pool. However, if the forum has more than one member, then the pool reverts to all members, not just those who have not joined the forum.

I am sure there is a simple solution - does anyone have the answer for me?

test_neq_relation.fp7.zip

[Ender]

Hi Jim,

It looks like this has come up before:

http://fmforums.com/forum/showtopic.php?tid/118241

[Jim Lah]

Ender,

Thanks for the pointer - I was beginning to think that a scripted method was going to be the only way - now you seem to have confirmed this - a dynamic solution would be much more elegent.

Jim

[Ender]

There's some other techniques discussed here:

http://fmforums.com/forum/showtopic.php?tid/128500

But I think the refresh is still required no matter what.