Hi:
htmSQL is part of SAS/IntrNet and while SAS/IntrNet does use ODS, very little of htmSQL uses ODS. Usually, you create htmSQL data queries to create custom HTML forms based on SAS data sources.
I remember doing something similar to this when I had access to SAS/IntrNet. As I remember, we built one page, that was the first query -- perhaps querying for Region. Then the results of that query built a second form on a second page that showed what they had just selected and then gave them more choices. As I remember, we used hidden form fields to pass input from the first query and to the second form, so it could be used in a second htmSQL query -- then based on what came back from the second query, they had a choice of what they wanted to run -- and then we kicked off a Graph program using the Application Dispatcher.
For more help with SAS/IntrNet and with htmSQL, your best bet is to open a track with Tech Support.
cynthia