InfoPath Dev

I have not found a way to add a database connection as a primary connection to an exisitng form. As far as I can tell you must create the form using the ''New from dataconnection'' wizard

Only the main connection can be submitted to a database. When you submit to a database every field in the main connection under dataFields is submitted, you cannot specify single fields

I'm a bit confused on what you are asking,,, You have a repeating table and a secified value? If so you could use conditional formatting on the table to hide rows which do not apply. I think I misunderstood you, can you explain it again please

Where is the drop down list getting it numbers from? I just tested it using a table from my database and it returned highest number

In that case can you delete and recreate the suspect connection in your exisiting form? Only problem with that is the fact that you will have to fix all your rules that used that connection Back everthing up before trying something like this ;)

To investigate the data connections I would create a new form, then recreate your 2 data connections and see if they turn out the same way I dont think the error message you got is anything to do with your connections, can you copy and paste the view into a new view (you would have to reapply rules) and delete bad one I have had views go bad on ...

After you have setup the dropdown list double click the field from your datasource to get it properties (the properties of the field not the properties of the dropdown list) You can then enter a default value, use the max function and choose the same field you got list from

Infopath 2003 + 2007 behave differently regarding preview and the selected view

ok, thats a long post, in short, you want to get data from a row in a repeating table but always end up with data from first row? Assuming I understood correctly. Infopath uses the first row because it forgets which row you where using. To avoid this create a field outside your repeating table. Change your rules so the first thing it does is ...

count(fieldname[fieldname = ''A'']) To enter this formula double click the text box for the total, click the fx button by default value, click insert function, double click count, double click the insert field, choose your field from the repeating table, click filter data, add a filter to select the same field which equals the letter you want, ...