Is it possible to use a global var in the lookup settings to create alternative dropdown lists for a specific field? (see attached image)
REASON: Form contains a dropdown to select an employee. -> SELECT all employees FROM empTable
Problem: When an employee is inactive/terminated, Not necessary to show inactive employees -> SELECT all employees FROM empTable WHERE inactive = TRUE
HOWEVER: The historical data (old records) need to show the employee name in grid/form prior to employee status set as inactive -> SELECT all employees FROM empTable WHERE inactive = FALSE
[ATTACH=CONFIG]n68365[/ATTACH]
