...
- Access the Queries section of Aeros Vision.
- Open the Query you wish to add an "In List" option to in design mode by clicking the pencil icon.
- In the ribbon bar, click the Optimize button.
Click OK when complete to confirm. - Click the Save button next to the Optimize button.
- Click Yes to also save the Query.
- Exit the Query designer.
- Under the Tools / Settings drop-down listing, select Manage Data Models / Connections.
- Within the list of Data Models, locate the item named "Model - {Your Query Name}" and click the box/pencil icon.
Your Query Name being the query loaded above in Step #2.
- When the Data Model Editor opens, locate the table containing the column you want to add the In List option to.
For example, if you want to add an option to lookup State Codes on a Customer, locate the Customer Table (#A)
- Then locate the column you wish to add the lookup too (#B).
- Then click on the Configure Default Editor button. The Value Editor screen will appear.
- Chose the Type option of Query (#D).
- Select the Query you wish to use as the Lookup (#E).
- Select a Display option (#F).
- Select a Value option (#G).
- Click Save & Close to exit the Value Editor screen.
- Click Save & Close again to exit the Data Model Editor screen.
- Click Close to exit the Data Model Listing screen.
- Now, when running your query, the option should now be a list.
...