InfoPath Dev

 Ah ok makes sense, because all the fields are in a repeating table that's why its prompting for this...

I wonder if the attached will work. On the save button, after your last submit, I added logic to set the query field to the ID, and then requery - Not sure if this will do it, we may need to add a secondary data connection to an XML file (saved as a resource in the form) and set that to the ID to save it till after the second submit - Or you might ...

So - if you are talking about the dropdown when promoting a field that repeats (i.e., the field is repeating or in a repeating group) - if the data is numeric, you'd have the option of sum - that would sum all the values for the repeating node. Count is a count of nodes. First is the value from the first instance - last is the value from the ...

I'm trying to create a questionnaire form. Form is sent as email to users. Main connection is tied to a MS Access DB table that has fields: username, id, and response(yes/no).  DB should update with only current user response. We do not have share point. Thank you!

Is the issue with newly filled out forms? Or forms you filled out prior to promoting the column?

 Thank you. I'll see if I can make this work. I'm really new to workflows.  

 Hilary, We are saving the record, setting the title field by concatenating, and the saving the record again so we can populate the title field. However, after the record is saved, the record displayed is the first record in the list, and we want it to stay on the record we just saved. Attached is the latest version of the form, the ...

 It seems my image didn't attach - the drop down box contains first, last, count sum etc 

 Hi, I hadn't realised (still finding my feet with InfoPath) when you create your form and plan to publish to SharePoint you get the option to create the columns for the form - great. Can someone please tell me, when you get this option you also get a dropdown in the functions section as below. What does this apply to? I know what ...

I am promoting using (first) but still not showing up in columns even with (merge) not working.