InfoPath Dev

If you want a browser-based, InfoPath form to be displayed to users in InfoPath and have the data submitted to SQL, you'll need code, you'll need a web service, or you'll need a third party tool. This has been discussed previously, such as here, here and here. This is a good read as well. Good luck.

Yes, I am trying to accomplish in InfoPath 2010. I have 2 list... List A = Route, Mileage (calculated based on Route) and Zone(calculated based on Mileage).  List B - Route (Lookup from List A). On my NewForm.aspx (in InfoPath 2010) for List B I have the Route dropdown list which is working.  I then need to be ...

Jimmy, Thanks for your help with this. I look forward to receiving the newer copy soon. Many thanks. Padraic

Hi- I responded to the other (duplicate?) question. I think what you're looking for, if you're working in InfoPath, is called cascading dropdowns. A quick Google search should yield a bunch of tutorials. Good luck!

 Are you sure that the URL to the webservice is correct? Web service URLs do have a ?wsdl at the end. It sounds like the URL is returning data that InfoPath is unable to interpret.

I think what you're looking for is cascading dropdowns, which is very possible in an InfoPath form, but it sounds like your question does not involve InfoPath. I don't know whether cascading dropdowns are available out of the box on SharePoint lists. Some info here, here and here. Good luck!

Hello Padraic,   It appears that the trial version you had was newer than the full version you got.  We have to update the trial version periodically to update the expiration date, but as there hadn't been any other major changes during that time, the full version hadn't been updated.   I've asked some other members of ...

If I have a List with two columns, Name and Phone Number. Then I created a new list where I have Names in a dropdown being pulled from the first List. I want to autopopulate Phone Number on my NewForm.aspx based upon my selection, I jsut can't figure out how. 

I've paired it down to 2 data connections. One pulls a dozen or so items from one list but the other powers a filtered text box value (@Level[@Title = Account] -Get the value of the account level where the list title field equals the account selected in the dropdown.) I've put the 2048 account values on the form but the data ...

You can't do this with InfoPath's builtin functionality, but we have a time-tested way to accomplish this relatively easily with qRules.  If you can create a simple sample form to demonstrate the tables you want to copy, inject the trial version of qRules in it and attach it to this thread, I can modify it for you to ...