Creating a Checklist Lookup

Keystyle Support Team -

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:

  1. All selected columns must be data type varchar
  2. The FROM Clause is fully qualified [database].[dbo].[table]
  3. The first selected column represents the Database Value
  4. The second selected column represents the Label in the drop down

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk