Configure dynamic list validations
You can create validations that provide a dynamic list to the user. We recommend using dynamic list validations. Dynamic list validations can be constructed to automatically pick up and display changed values. A dynamic list validation can be created using a drop-down or an auto-complete component.
For example, XYZ decides to create a dynamic list validation. To do this, they create an auto-complete validation that is validated by an SQL statement. The SQL statement returns the names of all users who belong to the Support Team security group. If Security Team membership changes, the validation is automatically updated with the current values.