InfoPath Dev

Hello! My infopath form is tied to an SQL db, and I need to create invoices with sequentially increasing ID number. Is it possible to do it with infopath? Thank you!

Thanks

I am creating a form connected to a SQL Database. I would like to filter rows according to the selected item in a drop-down list. For example, by selecting the company name, i would like to see its address and contact name. Right now i managed to retrieve the data for individual fields by applying a rule on the dropdown that modifies the field's ...

Hi, I already tried this tutorialhttp://www.infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18fb2c5bac85 and it works fine. The problem is when I do the same with a form connected to an Access db, and append the [../ID = current()] xml statement at the end of the Xpath it doesnt work as it is supposed to. What do i do wrong?

Unfortunately I cant change the default view to the page with the query button, especially because I have queries on multiple views. There must be a way to set the button not to switch to default view after clicking the button, or the utility of multiple views is quite limited, unless there is a different way to have a form with multiple ...

I also tried with a ''send'' button and the behavior is the same

Btw, i tried doing what you sugested, but no changes.

Hi Shiraz, I am using Infopath 2003 SP2 and today I also tried with infopath 2007 (as you did, I was also thinking hat it was related to the version I was using), but the result is the same :( Thx for your help!

Hi everyone, I have a problem that is really bugging me: I created a form connected to an Access db, which has multiple views (A and B, to make it simple). in view B i inserted a Query button and the problem is that when it is pressed the form switches to view A. This is driving me crazy!!! Any suggestions? Thx