Searching via portals - I cant believe I haveto ask this question

[spongebob]

I cant believe Im actually asking this question...Im using FM since donkeys years and have developed 6 billion dbases but this simple thing escapes me...it must be too simple thats what it is anyways here goes:

I have a file with a portal. So far so good? That wasnt complex was it.

Now, in the portal I have one field one each line/record in the portal. The field is called TempText. (ie the portal table has a one single simple field in it).

HOW do I search for all the records that have

the word HELLO in one portal line AND

the word HITHERE in another portal line AS WELL?

If I do strg-F im in find mode, I can type HELLO into the first portal row but how do i get a second portal row in the request so that I can extend the request and do an AND in the portal?

Can I do that? Can I do that in a script?

This is so ridicoulous Im embarassed...ill just go home now...and probably the answer is really easy right?

Thanks!

Spongebob (depressed) :bye:

[Donald Clark]

Enter Find Mode, type Hello in the text field. Make a new find request and type Hi There. Perform the find and all parent records with both of those criteria will show. And, yes, you can script it.

Don't feel bad-sometimes we can't see the forest for the trees. Happens to everyone.

[spongebob]

Excuse me for being mega dumb but If I do that it makes me a second "full request" and that will find all that have HELLO ---OR--- HITHERE in the portal which is not what I want. I want all records that have HELLO ---AND---- HITHERE in the portal.

[comment]

HOW do I search for all the records that have

the word HELLO in one portal line AND

the word HITHERE in another portal line AS WELL?

First, find the records that have the word HELLO in the related field. Then do another search for records that have the word HITHERE in the same field - this time constraining the found set instead of performing find.

[spongebob]

Ok that would work of course but is that the only way? Cant I somehow do a find and simply put 2 lines in the portal? That sounds horribly complex for such a simple request...

[comment]

It's not a simple request at all. You're trying to find groups of records that contain two distinct members. And it won't be "horribly complex" if you script it.

[spongebob]

okay! Thanks! Ill accept my destiny then and script it....