Variable portal filter criteria

[Rothko]

Hello again,

I have two tables, contacts and mailouts, in a small marketing solution.

Contacts can be either 'send invite', 'send press release', 'send call for submissions'. They can also be several at once.

On the mailout layout I would like to be able to select to which (or groups) the mailout should go. These records should then show up in the portal.

Ideally, if I tick e.g. 'send invite' and 'send press release', both groups should show up.

I can't figure out how to design the relationship / calculated key fields. Any help much appreciated.

[Rothko]

The fool I've been! Ah, you decide finally to ask around, and then you find it yourself:

In the Contacts table, I already have a field 'MailOutType'

A text field and value list with the 3 options in the mailout table ('chooseTypeOfMailout').

The relationship looks like this:

Contact_ID_pk x Mailout_ID_pk

AND

MailOutType = chooseTypeOfMailout

[comment]

The first criteria is not doing anything.

[Rothko]

That's right.