Hi Everyone,

I have a file (Invoices) with many products for each invoice .

Each product have a name, price, quantity ... and stored into another (and different) table (LineItems).

These products (LineItems) are into the "Invoice form" (Invoice table) through a portal.

Unfortunately, when I'm trying to search for products in the "Invoice form" through the portal (by Find Mode) I got many results that have no common words with the search criteria (same problem with numbers , Quantity, Price) .

A search into their table layout (LineItems) will give the good results.

Anyone have an idea

Another thing : all the records have been imported to filemaker 7 (by Tab separated text).

Thank to the helpers ..

Nissim

Anyone Have an idea ??

Hi, Nissim. If you search a portal for something, the found set will be ALL THE PARENT RECORDS which have a related record that matches your criteria. Just like if you searched for something in a flat file, it would return all records that have that value in the searched field; in the same way, searching in a portal returns all records where the criteria is met, namely, where the parent record has a child record that meets the criteria. And when that parent-record set is returned, the portal behaves normally, that is, shows all related records in that portal.

You may be better off scripting this find so that the relationship the portal is based off of is changed when a find is performed in the portal. In other words, have a button labelled "Limit Portal Records to Product=Widget" (or something a bit more user-friendly but equivalent) that, when clicked, changes the primary key field for the portal so as to limit the matched set to those where the selected product is specified. This would involve creating a concatenated key of some sort... i can't think of exactly how it would be built at the moment, but maybe you see my point.

HTH,

Jerry