Can you perform a relookup on just a found set

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

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 10th December 10:15 howard schlossberg External User Posts: 1	Can you perform a relookup on just a found set 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

3 10th December 10:27 helpful harry External User Posts: 1	Can you perform a relookup on just a found set 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)