In an InfoPath 2007 browser-based form, how do I populate a drop down based
on a selection from another drop down? The drop down used for the initial
selection is populated from a SQL 2005 table containing two columns of data
(key field and description field). The drop down for displaying data based on
what was selected in the other drop down is to be populated from a different
SQL table that also contains two columns of data (key field and description
field).  Both tables are joined by a junction table containing the key fields
from both tables. With this SQL table structure, what must I do to autofill a
drop down as a result a user selection in another drop down? Any assistance
would be very much appreciated.
Thanks!
SteveNic