In order to create a Checklist Lookup for Checklists, navigate to Office Tools > Manage Checklist Lookups
Under "Select a Lookup", the drop down allows you to create a new lookup, or select previously created look ups for editing. To create a new lookup, select "Add New Lookup" from the dropdown.
Specify a name for your lookup.
Create a query that matches the above example and the following criteria:
- All selected columns must be data type varchar
- The FROM Clause is fully qualified [database].[dbo].[table]
- The first selected column represents the Database Value
- The second selected column represents the Label in the drop down