In this example, you use a central SQL list to show existing project numbers stored in the vault.
To create a project search card:
- Create an SQL list that displays all values stored in the card variable Project number.
- Create a search card with a combo box linked to the Project number variable. Select the central SQL list Project numbers as the Special value for the control.
- Set the default search card value to only return files, not folders.
- Create a new search result column set.
- Add some columns (variables) to the result set and save it.
- Select the new result set.
- Save the search card and test it in the search tool.