It appears to me that in find mode, I can popule one portal row only.
Question is how do I help my users with AND searches. Do a find, then do
another find but do not hit enter but choose constrain found set etc.
works, of course, but I'd like to make things easier for them.

It's an FMP 10 address system where every address can have many
keywords. Tables are

addresses
keywords
keywAdrJoin

I created an interface for OR searches that I might re-use: Users can
tick checkboxes in a global field that displays the various keywords
(and takes the ID of the keyword cklicked), GTRR goes to the addresses
that have least one of these keywords.

I have a vague idea I could use this global field to do an AND search,
doing loops with constrain found set etc.

Before I start that, is there some easier/more elegant system I
overlooked?
--
http://clk.ch

"Christoph Kaufmann" <clk (AT) tele2 (DOT) ch> wrote

AND searches only need one Request / Portal Row. You're seaching for records
which have DataA in FieldA AND have DataB in FieldB.

OR searches need multiple Requests / Portal Rows. You're searching for
records which have DataA in FieldA OR have DataB in FieldB. Portals act the
same in Find mode as they do in Browse Mode - tabing past the last Field in
the Portal Row creates a new one (I haven't got FileMaker here to test it,
but that may only happen if the Portal / Relationship is set to allow the
creation of related records).

Either way, you don't need to Constrain anything.

The real problem with searching via a Portal is that you can't do NOT
searches since the Omit toggle works for the entire Request, not just an
individual Portal Row.


Helpful Harry )

Helpful Harry wrote:


Thing is, I need addresses that have two keywords, and only addresses
that have both of them. Means I need to look in the same related field.

That's exactly what I couldn't make happen.

It is in my case, but seems to work in browse mode only.
--
http://clk.ch

On Mar 11, 11:11 pm, c... (AT) tele2 (DOT) ch (Christoph Kaufmann) wrote:

Right, so you need to enter both keywords into the address field.

I'm pretty sure that's not true, even if "Create related records" is
turned on for the relationship.

G

In article
<46252367-7a55-4dcc-9542-d416f3ae0631 (AT) o16g2000prh (DOT) googlegroups.com>, Grip
<gripdeveloper (AT) gmail (DOT) com> wrote:

You're right. I've just tried it on this computer and it doesn't work. I
was positive I had done it in the past, but obviously I was
misremembering. Apologies for any confusion it caused.

Helpful Harry )