Show only some portal records

[mahonia]

Within a particular layout, I want to show only portal records that have anything in a given field -

I have a many-to-many database:

People [table 1]

Organizations [table 2]

Affiliations [table 3, links tables 1&2].

What I want is to show in a Portal within People only records in Affiliations that that have a value in a field within Affiliations called "special role".

Doesn't matter what value is in role, just don't want it to be empty.

I read http://fmforums.com/forum/showtopic.php?tid/170110/post/176995/

but this seems a little different...

ideas??

[Kent Searight]

Use "≠" (not equal to ) in a relation between Affiliations and People. The key field "special role" in Affiliations will not be equal to a field you'll create in People, which you'll leave blank in the appropriate records.

I don't know what your requirements are but you may have to create another table occurrence to set up your new portal (as your old portal won't behave as it did anymore). Another option would be to consider a filtered portal that allows you to define the filtering criteria from 1 layout.

Hope this helps.