Hi all,
I have a button to retrieve student profile on a database and another button
where I click and I retrieve student schedule.

My questions are:
Once the student profile button is clicked I also want to retrieve the
schedule information automatically without clicking the second button (using
a rule to query second data source).

Once I click the second button, I have a drop-down list where I want to load
the different Semesters or Periods but when the information is retrieved from
the second data source, I get multiple drop-down boxes as records found.

I would like to have only on drop-down box with multiple entries where users
can select any particular semester or period.

Using infopath 2007, webservice (asmx) and VB.

Thanks.