InfoPath Dev

I think we figured out the problem... the table that all this data is pulled from does not have a primary key specified. The item number field *has* to be unique, so I suggested that they make that their primary key.

I developed an infopath form (sp1) for a client last summer and all has been working good until recently. At random times, the dropdown box on the form is completely out of order. There are thousands of values in it, so it is very hard to find what you want if there is no logical order to it. This dropdown box is populated by pulling data in ...

ok, i found that this might work: Application.XDocuments.Close(0) but if i hard code that into the form code...maybe it will close the first form, but what happens when it tries to close the second form after you press submit? then wouldnt it have to be (1) ?

Please respond ASAP!! I have a form that when you click submit: It is submitted to a sharepoint library (formA) a new form is opened (formB) the form code runs (formA) then it closes (formA) i tried putting the Close in a rule, but it ran the rules before it ran the custom code. so i tried putting this at the bottom of my code on ...

I find that if i want the query to work, then db1/tblA needs to be the main connection...but then submit does not work correctly. If i want the submit to work, then db2/tblB needs to be the main connection...but then query does not work correctly.

I have been stuck on this for days and would appreciate any help! Here is basically what we want to do: ---------- Database1/TableA = retrieve data from here Database2/TableB = write data to here We need a dropdownbox with ItemNumber(db1/tblA) on form load. The user selects ItemNumber(db1/tblA) and some fields below this are populated with ...

I am working with msmith0004 on this project. It now looks that the webservice is not inserting the data into the database because there is no information being passed to it. The dataset that the webservice is supposed to get is always empty.