Script Steps Reference
Table Of Contents
- Contents
- About script steps
- Script steps reference (alphabetical list)
- Control script steps
- Perform Script
- Pause/Resume Script
- Exit Script
- Halt Script
- If
- Else If
- Else
- End If
- Loop
- Exit Loop If
- End Loop
- Allow User Abort
- Set Error Capture
- Set Variable
- Install OnTimer Script
- Navigation script steps
- Go to Layout
- Go to Record/Request/Page
- Go to Related Record
- Go to Portal Row
- Go to Object
- Go to Field
- Go to Next Field
- Go to Previous Field
- Enter Browse Mode
- Enter Find Mode
- Enter Preview Mode
- Editing script steps
- Fields script steps
- Set Field
- Set Field By Name
- Set Next Serial Value
- Insert Text
- Insert Calculated Result
- Insert From Index
- Insert From Last Visited
- Insert Current Date
- Insert Current Time
- Insert Current User Name
- Insert Picture
- Insert QuickTime
- Insert Object (Windows)
- Insert File
- Update Link (Windows)
- Replace Field Contents
- Relookup Field Contents
- Export Field Contents
- Records script steps
- New Record/Request
- Duplicate Record/Request
- Delete Record/Request
- Delete Portal Row
- Delete All Records
- Open Record/Request
- Revert Record/Request
- Commit Records/Requests
- Copy Record/Request
- Copy All Records/Requests
- Import Records
- Export Records
- Save Records As Excel
- Save Records As PDF
- Save Records As Snapshot Link
- Found Sets script steps
- Windows script steps
- Files script steps
- Accounts script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
FILEMAKER SCRIPT STEPS REFERENCE 64
Related topics
Script steps reference (alphabetical list)
Contents
Relookup Field Contents
Purpose
Copies new values from the lookup source field into the records that make up the current found set.
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.
• Select Go to target field or click Specify to specify 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
or target field. If no field is selected, Relookup Field Contents returns an error code that can
be captured with the Get(LastError) function.
Compatibility
This script step is also supported in web publishing and in a FileMaker Server scheduled script.
Notes
• 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. For example, if a
field value is modified and a relookup is attempted before the data is committed, then
the relookup search will be based on the old data rather than the modified data.
Originated in
FileMaker Pro 6.0 or earlier
Examples
Show All Records
Go to Layout [“Data Entry”]
Go to Field [Table1::Invoice Number]
Set Field [Table1::Invoice Number; Max(Table1::Invoice Number)]
Relookup Field Contents [No dialog, Table1::Customer ID]