InfoPath Dev

 Oooh! Of course... nice solution, thank you!

Are you able to fill your first dropdown list ? You mean you need to fill droplist from first table and based on selection in droplist you need to fill second table ? In this requirement, I advise you go for code solution by using VSTA and ado.net. If you aware of C#, Ado.net and Xpath you can get this done accurately as you need. DC in your ...

The backend for this form is SQL 2008R2, the form is designed in InfoPath 2010 and will be used with the InfoPath form filler. In my SQL2008R2 table I have store information (Store number, Store Name, City, State, Zip) and in my second table I have more information about the store (Store Number, Opening Date, Owner, Manager). Store Number is the ...

In your case, this should do the trick:sum(field2) + sum(field5) * SwitchPage

I'm sorry for the confusion, allow me to clarify. I have two SQL tables. The first is for sales data entry and one of the columns for this table is "Store Number" and the data is in the format XX-YY-ZZZZ. Our form is designed to input data into this table and it works just fine. We also have another table that is simply the Store ...

 Looking back, my post is quite unintelligible...   I've added a simplified example.  I have two sections with tables in it, a button and a invisible field called "SwitchPage". As long as "SwitchPage" has a value of 0, the second section is hidden. If you press the button, "SwitchPage" gets set to ...

[quote user="Kamal_Kochar"]I have an InfoPath form published in a SharePoint list which is connecting to UserProfileService.asmx[/quote] Are you using client or browser-based forms?       You should use either client (Infopath Filler 2010) forms or, if you use browser forms, then through the web proxy service ...

I wish I could better understand your phrase:  " I want to have a field which gives the total of all the visible lists"  A list is a set of fields (and rows, basically a table, and you want to have a total of all fields in a few lists?

I've read over your post-question few times but couldn't grasp what you were asking.  In the title and first 2 sentences you ask "Howto use a dropdown list to set a value in a text box?" but in the last 4 sentences you extend on somewhat unrelated situation of using drop-down-lists only, failing to ...

 I'm not sure why this works but it did. I changed the store number to a dropdown box and used the secondary data connection for the lookup source. By putting the value at the number and the display as the name, it seems to work.