I know how to filter a portal list based on multiple fields. My question is, How do you filter a portal if you only want one value from one of the multiple fields?

For example:

I have a table called Cards with four fields. Call them 1,2,3,and 4. I have another table called Collection with one field. Call the field "style"

What I want is to create a portal in the collection table that will show all the records from the cards table that matches the value in the style field. For example, if I typed creature in the style field in the collection table, I want the portal to show any record in the cards table with the word creature is in fields 1,2,3, or 4. I can create portals where it matches all the fields, but I don't know how to create a relationship where a match is just some of the fields or just one.

Any help you can give is much appreciated.

You could do this by creating a calculation field in the cards table. This calc. field lets call it "match" would act as a value list of the fields you want. For instance: match= fieldone & ¶ & fieldtwo & ¶ & fieldthree & ¶ & fieldfour & ¶

When you relate your collection table (the style field) with the cards table "match" this should do the trick.

Greetings

Kip

Edited October 13, 200520 yr by Guest

That is awesome, thank you. By the way, what does & ¶ & do? Its the one part I didn't have.

Pilcrow as its called is:

http://en.wikipedia.org/wiki/Pilcrow

In filemaker is it used for multilinekeys...

--sd