List Lookups

Lookup is a powerful feature in AVEVA Work Tasks that allows you to fetch data from a List or a SQL Database. Lookup Settings is a separate module that allows you to create lookups and maintain it as a Lookup list.

The Data source for a lookup can be a Database or List. Database is used to populate lookup data from a database and List is used to populate data from an existing List. When you create a List or Form, the Lookup Input control can be easily linked to the desired lookups available in the Lookup list. Consider a scenario of creating a new user for the "User list". Details of the user like name, password, email, department and manager fields are required. In this scenario, Managers can be the existing users from the "Manager list" for which the lookup can be created.