Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / October 2007

Tip: Looking for answers? Try searching our database.

Cascading Controls - InfoPath 2007

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jmalm - 12 Oct 2007 17:33 GMT
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 - 12 Oct 2007 20:05 GMT
Search for cascading at http://www.infopathdev.com

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

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

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

> First off - I'm not a developer by any stretch of the imagination...
>
[quoted text clipped - 7 lines]
>
> Jeff
jmalm - 12 Oct 2007 20:09 GMT
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

> Search for cascading at http://www.infopathdev.com
>
[quoted text clipped - 11 lines]
> >
> > Jeff
Clay Fox - 12 Oct 2007 20:22 GMT
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.
Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

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

> 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
[quoted text clipped - 19 lines]
> > >
> > > Jeff
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.