This topic describes how to use a saved search to set and update values in fields linked from other tables. The ability to populate a linked field based on the results of a saved search provides more flexibility for populating linked fields than simple matches on a single field, and does not require complex formulas to achieve the same result.
While configuring the linked field set you will create an Update Fields action and a saved search which are used to set the default value of a linked field.
In the example below, the Companies table contains linked fields to Contract information. When the company is created or updated and its Date Updated field changes, the linked field set to contracts is updated with the contract returned by a saved search. The search finds the contract with a status of valid and which has the latest End Date of all matching contracts.
Note: Older releases of do not include the Create Action button. You must first create the necessary action by navigating to the Rules tab of the Table wizard. You can either edit an existing rule to access the Actions tab or create a new rule. You will need to save the action but do not add it to any rule.
Clicking the Create Action button from the linked field configuration screen opens a limited version of the Action wizard where only Update Fields actions are visible and available.
Click Create New Search to open the saved search window.
Configure the saved search to find the records you want to use to populate the linked field. Do not use run-time filters, since those require input from the user when the search is executed. Remember to save and name the search.
Close the search window to return to the Values tab.
Select the new search from the drop-down. Choose whether to use the first record returned by the search or all records.
For searches that return the first result, make sure the proper Sorting is applied to return the right record. You can click Edit next to the selected search to check the sorting configuration.
Using All Results in the search only works for linked fields that accept multiple values.
Related articles |