Help

Table Of Contents

Working with related tables and files

ILEMAKER PRO HELP 397

Important When a lookup is based on a multi-criteria relationship, a lookup will be triggered each

time a value is entered into any of the fields that are involved in the multi-criteria relationship. The

lookup is being performed each time a value is entered into one of the required fields. When all of

the requisite fields have values, the final lookup value will be copied into the lookup target field.

Related topics

About lookups

About relationships

Updating lookup values

Defining automatic data entry

Updating lookup values

If you change data in the match field of the related table or in the lookup source field for a lookup,

FileMaker Pro doesn't automatically update the data in the lookup destination field. To update the

data, you need to look it up again.

Important Relookup Field Contents updates all fields looked up by the match field across all

records in your current found set. You can't undo your actions when you update lookup values.

To update lookup values:

1. In the current table, use Find mode, or Omit Records in Browse mode, to create a found set

that contains only the records you intend to update.

2. In Browse mode in the current table, select the match field, then choose Records menu >

Relookup Field Contents.

3. When you see an alert message, click OK.

Note The Relookup Field Contents and Replace Field Contents commands no longer commit data

when they are performed. If your solution depends on the data being committed, you must explicitly

commit the data before performing those commands. For example, if you modify a field value and

then try to perform a relookup on that field without committing the data, the relookup search will be

based on the old data rather than the modified data. (For more information about committing data,

see

Committing data in records.)

Tip You can update lookup values automatically by defining a button to perform the Relookup Field

Contents command, or by defining a script that uses the Relookup Field Contents script step.