A cascading list shows a list of values where each item in the list may have a sub-list of choices, and so on, until you get to an entry that has not sub-list (called an endpoint). Once the user clicks on an endpoint entry, that entry is filled into to lookup field.

In this video we show how you can set up a cascading list lookup that displays data from a SQL table. The lookup displays a list of countries. For each country a sub-list of cities is shown. For each city, a sub-list of company names is shown and then a sub-list of customer Ids is shown. Since customerId is the endpoint, when the user clicks on the Customer Id, that value is inserted into the Lookup field.


Download component
http://alphamediacapture.s3.amazonaws.com/videos/ux_lookup_cascadingList.zip