I want to be able to do a relookup but only on records in a found set.
I've done the find, but the relookup fixes everything in the whole
database.

-S

squeed2000 (AT) yahoo (DOT) com wrote:
No...a relookup is only performed on the current found set. Maybe if
you can provide us some more info on what the lookup trigger field is...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

What I am saying is that my relookup is looking up on everything in my
database and not just on the found set. The database holds calls that
a sales person is making. A call is either Active or Complete. If a
call is complete I don't want the relookup done. So I am doing a SET
FIELD to the CALL STATUS field and setting it as "Active" and then
doing the relookup only on that field. But it is relooking up the
whole database.

-S

In article <1124919935.501333.114210 (AT) g43g2000cwa (DOT) googlegroups.com>,
squeed2000 (AT) yahoo (DOT) com wrote:

It doesn't say anything there about performing an actual Find, but
maybe that's just a typo.

If you perform a Find on Call Status = "Active" and then the Relookup.
It should only Relookup the data / fields for the Found set of records.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)