InfoPath Dev

 In that case you might take a different approach and use a button control to trigger the calculation / recalculation when the form is used. That way your user could fill in the '2016 (Deficit / Surplus' control filled in first and then the Text2, Text3, Text4, etc. controls next - the logical flow.  Simply ...

 If I correctly understand the secondary data you mention, I also employ process check/confirmation fields when I design a template, but I don't delete them or set up a different view.  My practice is to insert a section/group at the bottom of the form called "Hidden Fields" and I control the appearance ...

 Hilary, let me say thank you very much!!  Your filter syntax worked perfectly.  It frustrated me for a few hours until I realized that I'd been typing "." instead of '.' when setting the substring-before() break point.  Duh!?!  Once I used '.' it worked like a charm. I was able to build the ...

 Would that be "substring-before(max(@fieldname, ".")" -OR- max(substring-before(@fieldname, ".")

 Hillary,  Hello.  I followed your suggestion and dragged the FY and Request number columns data in from the secondary data connection SharePoint 2007 site library into the form template.  I ran a preview and the data in these columns comes in with ".000000000" after the actual number data, so the Fiscal ...

 First, with what version of InfoPath are you working?

I am using InfoPath Designer 2010 to work on an InfoPath 2007 compatible form that currently works off an existing SharePoint form library.  The form is a request for equipment.  Each request is identified by an incrementing number constructed from the Fiscal Year column/field and the next request number column/field.  ...

Once the Manager makes her/his decision what do you do with the form?

I am using InfoPath Designer 2010 and submitting data to a SharePoint Server 2003 site.  I have a repeating table with three data fields.  How do I get the data in the three repeating fields to aggregate into three single columnar lists and then successfully have the aggregated data submitted into ...