Lookups
Forms can get information such as product descriptions, prices, and pictures from databases or other systems and enter it in the form for you. Lookups make filling out a form easier and more accurate. The cell in which you enter a value is called the lookup cell.
When you enter a value in the lookup cell and tab out, data is retrieved and entered in other cells on the form. If you click a button such as Save before the lookup is complete, the form is not saved until the lookup is complete.
NOTE Lookups can't be done if the form is offline. When you put the form back online, you must enter or change the value in the lookup cell and tab out of the cell. This allows the lookup to get the necessary data and enter it in the appropriate cells on the form.
To perform a lookup
- Enter a value in a lookup cell and press Tab to leave the cell. You might
be prompted to enter some information, such as your name and a password. The
value that you type in the lookup cell is then searched for.
- If the search fails, a message is displayed.
- If a single match for the entry is found, the information is entered on the form.
- If multiple matches for the entry are found, the Lookup Results dialog box appears. The first five columns of data for each match display in the dialog box. If you need to see all the data for a specific match, click Details; then click OK to close the Details dialog box. Select the match you want and click OK. To cancel the lookup, click Cancel.
NOTE If you click a button such as Save before the lookup is complete, the form is not saved until the lookup is complete.
Feedback