Hi All,

Requirement:
I have 2 drop down list.
Suppose I have a table TRAINING contains these two fields LOCATION AND COURSECODE) and in the first drop down i am selecting LOCATION and in the second drop down list i want the COURSECODE should be selected automatically for the specified LOCATION once i select the LOCATION from the first drop down list.

Could anybody have any idea how to accomplish this requirement.

Cheers,
Satya.

This message has been edited. Last edited by: Kerry,

Satya,

This is called chaining. You can do a search on that keyword in the forum. I'd also suggest that you read the chapter on the HTML Layout Painter/HTML Composer (depending on your release which should be in your signature BTW). You can find this chapter in the Developing Reporting Applications with Graphical Tools. Click the doc link in the upper right-hand corner of this page and search for this manual.

Also, please update your signature with your product suite, releases, and platforms.