Hi,

I try to do a search in the portal table. The portal is connected to another table to list all the items.

When I search the portal for a specific word, it list every records despite the fact that I only want to see the record with the specific word.

Is there a thing I didn't do?...

Thanks.

K.C.

When you perform a search in a portal, the result is all the *primary* records that have one or more related records that match the search criteria. In other words, the find returns primary records, not related records.

I think you may need to fully explain what you are trying to achieve.

Hi,

Thanks for your reply! I would like to do a regular search in the left portal and have it returns only the desired result.

For I try to search for the item "1" in the left portal in the quotation detail. It also return the other items.

Is there something i didn't do in the relationship?.. Thanks.

K.C.

test.fp7.zip

I am afraid you are missing the point: a portal ALWAYS shows ALL related records, regardless of any found set.

I try to search for the item "1" in the left portal

This will find all quotations that are related to item "1" through the left portal's relationship. Since this relationship is based on a global field, it will simply find all quotations - or none, depending on the global value.

To filter the portal so that it shows only products that meet a specified criteria, use the global filtering field to filter the relationship, or filter the portal itself (or both).