This is my 3rd post and I am newbie to Infopath 2010.
I have a question about 'submit' button on the form.
Right now I have a form with one dropdown, one textbox, and 2 buttons which are <Run Query> and <Submit>
I have a SQL database table (ITEM) which has 4 columns; ItemNumber, Quantity, Location and Name.
Senario: A user is going to choose a location from dropdown menu that is populated by another table in the SQL database. He is also going to type in his name in the textbox.
When he clicks <Run Query>, the ITEM table that is in SQL displays with only two columns, ItemNumber and Quantity.
The table will have Item Numbers already filled in, but all of the quantity fields will be blank, so the when the user clicks <Run Query> it will display a list of Item Numers, and the user will fill in the quantities for those specific items.
After they are done filling in the quantities, the user will click the <Submit> button.
When the user clicks the <Submit> button, I need all of the Item and Quantity data to populate the database, but I also need their location and name to go into every record that they submitted. So if there are 10 Items in the table, they will
fill in quantities for those ten items, and the
View Complete Post