InfoPath Dev

 Glad you got it working!

 Glad it's working. Thanks for sharing the solution.

xml

Im posting my xsn, and I will post my mapping.xml following.

Grrrr I am really pulling my hair out with this one  - cant work out the best way to do it! I am creating an Overtime submission form for staff to submit hours worked overtime.  There is a field which allows the user to put in how many hours and minutes they have worked over for a particular month.  I was going to use a time field ...

Im Trying to use the submit to sharepoint list tool, and Im getting Errors occurred submitting to list: One or more field types are not installed properly. Go to the list settings page to delete these fields.. Is there a way to determine which fiield it is complaining about?

Hilary, I think I have found a solution thanks to your expert guidance. When I unchecked the "Include data for the active form only" checkbox in the data connection for retrieving the ID from the form Library, I found that it just returns the first ID in the library. If this checkbox is checked, it doesn't return any value. ...

If the referreral field is not getting set in the form, of course, there is no data in the field to submit, then. Perhaps deactivate most of your rules and just try your submit and query rule to see if you are getting data back in your query? Drag the query datafields onto the form to verify you have the data you'd expect?

Hilary, I think I have found a solution thanks to your expert guidance. When I unchecked the "Include data for the active form only" checkbox in the data connection for retrieving the ID from the form Library, I found that it just returns the first ID in the library. If this checkbox is checked, it doesn't return any value. ...

Hilary, The referral field does not obtain a value from the ID of the library. This field remains blank throughout the process. I've used the full Xpath for the referral in the main form when updating the ReferralID as a test column and it submits o.k. However, I can change it to reflect your advice. I don't get any errors ...