There are two ways to create a dynamic list:
- From scratch, just like creating a database resource
- Using an existing database resource and the Build Dynamic List Wizard
Once you have a dynamic list...
Simply attach it to a field and select the list fields you want to use as the display and return values for the field.
This display/return value set up is particularly useful for foreign keys. In the example in the video, the value stored in the employees table is the integer department ID. However this doesn't mean much to the user, so our dynamic list is used to show the user-friendly department names in the drop down list while maintaining the integer valued foreign key ID in the employees table.
For more information, more complex uses and further examples, check out the Xi Documentation