Populate drop down based on selection for another drop down.

S

SteveNic

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Formatting Rule: Diplay Section based on Selection in another section 0
Help with drop down selection and populating related data... 9
Auto Populate Fields based on Drop Down List Selection 2
Programmatically fill drop-down list based on another field's valu 1
Filtered drop down list 2

Top