Cascading Controls - InfoPath 2007

[jmalm]

First off - I'm not a developer by any stretch of the imagination...

I'm trying to get the results of one "Drop Down" box to appear into another
drop down control. I have 2 SQL tables I'm receiveing information from.
Here's the scenario: You choose a Store number from one drop down box -- I
need to have the matching Employee number appear in another drop down. I have
the TRANS SQL to make this work.. Is this possible to do in InfoPath?

Thanks,

Jeff

 

[Clay Fox]

Search for cascading at http://www.infopathdev.com

There are multiple blogs and posts on how to accomplish this.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[jmalm]

Thanks Clay -- I was able to successfully get the cascading to work with the
use of the "Filters" in INfopath.. However upon publishing this form with
Infopath Services Compatibility mode for browsers, I was very disappointed to
learn that Filters do not work with Infopath along with the ability to submit
to a database.. (my bad for not checking first..)

Thanks again

 

[Clay Fox]

Yah there are some limitation on the browser forms but I may have a solution
for you.

Check out the Database Accelerator download at http://www.qdabra.com.

It has web services that allow you to perform multiple queries and submit
data to a SQL database, even with a browser form.

So you can have the first dropdown trigger a query of the second table for
the selected value and return the data for the drop down, which will give you
the cascading you want. And then you can send all of the data in the form to
as many table as you want.

Contact me if you need assistance or a demo.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com