AND searches in Portal fields

[anyjoe2000]

I have a fmp 8 database that’s used for sales quotes. It uses one table for the header info and a related table for the lines joined by a quote number. Im working from a header layout with the lines portaled in. I would like to do a “AND” find on the lines inside the portal. Lets say I want to find all quotes that only have BOTH part 100 and part 200 quoted on it. I can only seem to do OR finds that would include quotes that have part 100 or part 200 or both. Any ideas?

 

[JeanW]

The related field showing in the portal needs to be redefined as repeating.
Don't use it to store data in the repetitions.

You have to redesign the search and use a script for performing a find, rather than letting users manually enter find mode.

 

[anyjoe2000]

That sounds like it would work. I managed to get another solution to work as well, I created a few identical instances of my line table with identical joins to the main table. Then I duplicated the layout to create a sort of search only layout. I replaced my mutiline portal in this layout with my new portals limiting them to one line each, so the users can enter as many choices add instances I supply.
I can see that your way would probably be more efficient though.

 

[JeanW]

I never let a user make a search on a regular layout.

The search is always scripted, with a special search layout.
A layout with a header and body part and a Trailing Grans Summary.

Header is for the Back button and the information how to use the search engine.

The body is for the fields where the user can search on. You will never have a search on ALL the fields in a data input layout (unless there's something wrong with the design)

The Trailing Grans Summary part is for the buttons to manage the search.
When you put this layout in View as List you can play with the AND, OR and Omit to get the desired results.