Relookup Field Contents
 
Purpose 
Copies new values from the lookup source field into the current found set.
See also 
Updating lookup values
Creating scripts to automate tasks
Format 
Relookup Field Contents [No dialog; <table::field>]
Options 
 •
Perform without dialog prevents a dialog box from displaying when the script step executes that lets the user confirm field information.
 •
Go to target field specifies the field that is the target of the relookup operation. FileMaker Pro moves the cursor to the field you specify. This must be the match field for the relationship upon which the lookup is based, not the lookup source field or lookup target field. If no field is selected, Relookup Field Contents returns an error code that can be captured with the Get(LastError) function.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server scheduled script 
Partial 
FileMaker Go 
Yes 
Custom Web Publishing 
Partial 
FileMaker WebDirect 
Yes 
Runtime solution 
Yes 
Originated in 
FileMaker Pro 6.0 or earlier
Description 
 •
The target field specified for the Relookup Field Contents step must be an editable field.
 •
Relookups are only performed on the found set of records in the active table.
 •
Calculation fields cannot be used for the Relookup Field Contents command. If you use the Relookup Field Contents command, and you're using a calculation field as the matching value, you must specify one of the input fields for the calculation as the field parameter for the Relookup Field Contents.
 •
When you use the Relookup Field Contents script step, the data must be committed first before the operation is performed, or you may get unexpected results. See Committing data in records.
Example 1 
Finds records that have matching values in the Customer ID field, then updates all lookups in the found set based on the relationship that uses Customer ID as a match field.
Go to Layout [“Invoice Details"]
Find Matching Records [Replace; Invoices::Customer ID]
Relookup Field Contents [No dialog; Invoices::Customer ID]
Related topics 
Script steps reference (alphabetical list)
Script steps reference (category list)
Was this topic helpful? Send feedback.