InfoPath Dev

Excellent!  Glad to hear you figured it out.

Here is the file.  By the way, I really appreciate all your help.

Ah! That's done it. I originally pasted it in, so it was underlined but I hadn't actually chosen it from the field picker. That's sorted it, thank you!

Your "group2" field in your formula -- You've selected that using the "Insert Field or Group" button, right? So that it is underlined?

Thank you for your help! I have a couple follow up questions about DBXL- What happens when the form is deleted in SharePoint? In addition to our reporting needs, we are looking to move data off of the content databases and solely store them in SQL Does the software work for mySQL, Access DB, etc? Who can set up the mapping? What ...

 Thank you anyway for trying mgarant.  

Hi Catharine, Were you able to solve this issue? Let me know if we should continue to track this, or if it is resolved. Thanks!

Can you attach your template? Under the Options tab, you can attach a file. As I said earlier, we use this method in browser forms with no issue, so it must be something in your form or in IPFS. I can take a look, see what happens when I try to publish it.

Well - I got through all of that finally...  There are no errors or comments in design checker.  The form works perfectly in preview. Now when I publish through the admin approve process I get an error that there is an invalid number field.  I am still just trying to test and get it working so  I have only two ...

humm... I have no idea how to do this i'm afraid...   Maybe someone else could help on this?