Matching This AND That

[SteveGriff]

Hi people,

I've got FieldA that has the following checkboxes - "Skoda", "Lada" and "Ferrari".

What I need to do is have a portal that views all records that have both "Skoda" AND "Lada" checked. I've managed to do a calculation field - Calc which uses "Skoda linebreakchar Lada" that manages to show entries that contain Skoda or Lada.

Help!

Thanks,

Steve Griff

[LiveOak]

You are working to hard. What you need is a multi-key, not a calculated compound key. If you already have a checkbox field, the multi-key needed for the left side of the relationship is automatically created for you. When you check multiple cars, what is actually entered into the field is:

Skoda <cr>

Lauda

If you just relate this field to the car name field in another file, create a portal, and check two cars, records for both car types will appear in your portal. When a text field key has multiple items separated by carriage returns (a multi-key) it will match multiple related items.

-bd

[SteveGriff]

I need a ice cold beer... Thanxs!