InfoPath Dev

 Those look like some interesting tools and I will definitely be checking those out but this isn't quite what I'm looking for.  Basically I'm looking to do a JOIN on two tables and be able to submit to and query from those two tables in one single form.

 I was afraid the answer would be in coding. That is outside my abilities. I was able to find a bit of a hack -- I duplicated the status query field a few times to cover each field that I need to use. On each dropdown I changed the external lookup to display what I wanted but kept the value as the store number. Then I used a rule to cause ...

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 ...

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 ...

 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.

I have a very basic sales data entry form. You put in the store number, the sales period, the current year, and the amount sold. This InfoPath 2010 filler form is setup and submitting to the SQL 2008R2 database just fine.  But I want to make two changes to help with the data entry and both are to add a drop down box that will then set a ...