Newbie Questions

Re: Filtered Display

Greg Collins — Mon, 26 Feb 2007 18:33:07 GMT

You will need to use code (or possibly rules) for this. You need to set the query parameters for your data connection with the selected values, and then query.

Re: Filtered Display

5070707 — Sun, 25 Feb 2007 12:18:27 GMT

Greg, Thank you so much for the help. i did use the cascading article, built a small SQL table for my needs and filtered using the form, worked perfectly!
I'd like to take it one step ahead, maybe you can give me a place to start as well:
now that i have my cascading dropdowns, i want to pick these two data bits and query another SQL table which contains all the relevant data that meets their criteria's..
any suggestions?

Thanks!

Re: Filtered Display

Greg Collins — Thu, 22 Feb 2007 17:39:48 GMT

There are some good articles in the "How-To" section of this web site that explain about a "Cascading Drop-Down" -- which is what you are trying to do.

The problem you are encountering is that there is nothing by which to actually filter. You need to have "software" tied to "word" in order to filter. With two hard-coded lists, this is not possible. You will need to use a secondary data source to accomplish this.

Do a search on this site for "cascade" and read the articles for more assistance.

Filtered Display

5070707 — Thu, 22 Feb 2007 13:19:03 GMT

Hi all,
trying to do the following using infopath 2007
two combo box:
first one - contains manually input values of "software' and
'hardware'
Second one contains manually input values of "word" "infopath" "video
card" "hard drive"

can i (using infopath integrated tools) filter this, that when a user
choose "software" in the 1st combo box
the second one will show only relevant values, IE: "word" "infopath"
or if hardware, only "video card" "hard drive"?

been killing my brain here...(no programming experience at all)
any help would be greatly appreciated even if it's using 3rd parties
suggestion.

Thanks,
Me,