searching on several criteria in a portal

[goanna300]

I am trying to find records in a portal by specifying more than one field value.

eg: in a database of "farms" I wish to find every farm which feeds carrots to rabbits.

So I need to find all farms in a layout whose portal shows "rabbit" in portal field "animal" and ""carrots" in portal field "food"

If I enter "find" mode and type the values as above, this does not produce the result.

Any clues as to what I am doing wrong"

Steve

[RalphL]

You find every record that that has rbbit in animal plus every record that has carrots in Feed. You wanted an AND find and got an OR find. This is the way it works.

To do what you want you must do the find in the related table. Then make a multi-line global key field which is used to find the related records in the first table. To make the multi-line global key field requires a layout with only the key field on it. Go to this layout and copy all records. Go to a layout that has the multi-line global key field and paste into this field. Use a go to related record show related will produce the set of records you want.

[goanna300]

Thanks for the info on portal-searching limitations, Ralph.

I just found out how to do searches easier:

Create a concatenated field in "Feed" database which shows values like "rabbitcarrot"

Then do a search on that.

Steve