From Dwayne Wright www.dwaynewright.com
info@dwaynewright.com
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.
Got To Know Factor - 10
Here are some links to other posts that might be of interest in regards to this topic...
Auto Enter: Lookups
Lookups In Portals Not Working Reliably
EXAMPLE: Portal Lookup Failure
The Lookup Function
The Lookupnext Function
EXAMPLE: LookupNext Function Explored
A Second Look At The Lookup Functions!
You Cannot Lookup A Field Without Access To It
Potential Issue: Lookups In Portals Not Working Reliably
Lookups Explored
The Ups And Downs Of Lookups?
=
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.
Posts
