The FileMaker Relookup Field Contents Script Step

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Relookup Field Contents is used to replace information in lookup fields with the current related information for all the records in the current found set. Much like entering information in a key field triggers any associated lookup commands, the relookup will do the same thing, except it will do it for all the records in the current found set.

HOW IT IS USED
It is used when the lookup data needs to be in synch with the related data (and that related data has probably changed). I do not use the relookup command myself any more. It has too many limitations and may trigger relookups on data I don't want a relookup for. I tend to use the REPLACE command with a calculation equal to the related data instead of a relookup.

FYI...
There are two options for this script step. One is to specify the key field that you want all the lookup fields to be activated upon. This means you specify the key field in the relationship you want to relookup with. This field does need to be on the current layout to work. All fields that have an auto-enter lookup specified for that relationship will have the data replaced with the latest version of the lookup data.

The second option is to perform the script step with/without a warning dialog box, because again there is no undo.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.