InfoPath Dev

Hello all. I am working on a form that has an information view and 27 corresponding print views.  I want the information view options to determine on action what page prints.  The end user will enter information on the information page which will then populate into the necessary spaces on the printable views from there i want them to ...

Hi Anuma Thanks for the reply and the links they are very useful and do exactly what I want. Interesting approach without the code! I like it.  Thanks again Cheers Kevin   

You have a few choices. One of them is changing your form's SQL query in code before running it to make it dynamic -- that is, to add a "Where" clause that includes the information typed in your text box. Another is to build or buy a web service. A third choice would be to go ahead and return all the rows when you run the query, ...

Yes, it is. My form is fully trusted. So, I uninstall and reinstall the new version everytime.

Hi Santosh, While using master-detail table,It is populating more than one dropdown list box's in the same form.I want to use only one dropdown list.

Hi, I am designing a new infopath 2007 form for my project. I have a Text Box in the form,which allows user to type user names. Now the issue is I want to connect the textbox to active directory. So when a user type first name or last name It should pull the name and email from active directory to the textbox's. Please let me ...

Thanks, but I dont know SQL.  Now I'm totally lost.   One problem I'm having right now is when I use the "Run Query" button it returns all records in the database.  I'd like to be able to narrow down the results based off a partial name match.  And then I would like to be able to choose that one record.

 Hi sirri, What is the problem you are facing while using Master-Detail table?

Hi johnmacd, While taking the data connection to Data base, after selecting the Data base you will find one button “Edit SQL” in Data connection Wizard. Click that button and edit the SQL as per your requirement, then test your SQL statement by clicking on ‘Test SQL Statement’ button. In this way you can select the records by using where ...

Not working Ravi.