Filtering a Portal

[Heathbo]

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.

[Kip]

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, 2005 by Guest

[Heathbo]

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

[Søren Dyhr]

Pilcrow as its called is:

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

In filemaker is it used for multilinekeys...

--sd