Synchronize Lookup

Previous Next

See Also

Tip

Synchronize lookup windows with the window from which they are called.

Background

You can limit the number of queried records in lookup windows using values in the calling window as search conditions. If the lookup window pops up and performs a query, the values of the corresponding foreign key columns are copied and entered as query conditions.

When to use

Set the Synchronize Lookup property to All Editable Fields for those lookup windows that are often queried from foreign key fields in another window.

To synchronize a lookup window with the window from which it is called:

1. Use the Class Catalog to select and open the appropriate lookup window.
2. Open the Property Inspector, and click the General tab page.
3. Change the Synchronize Lookup property to one of the following:
· Non-editable Fields.

The lookup will synchronize with all foreign key fields that are either non-displayed or non-enterable. This is the default.

· None.

The lookup will not be synchronized with the calling window.

· All Editable Fields.

The lookup will synchronize with all foreign key fields that have been updated by the user.

4. Save your changes.

Limitations

Lookup windows cannot be synchronized from joined column fields in the calling window. Also, if the user performs a query in the lookup window, synchronization with the calling window is not applied.