Example   Source
  Menu  | 
<<
>>
 |  Run as  
Creating a dependent lookup where the items depend on the value of another column which can change at run-time can be implemented by specifying a parameter placeholder the dependent lookup SQL with the same name as the column on which it depends. At run-time whenever the value changes in that column the dependent lookup items will be refreshed based on the new value. In this example the list of cities is dependent on the selected country. When the selected country changes the parameter @country is automatically assigned the value in the country field and the city list refreshed.