Microsoft Access

Re: Submission error with repeating table within a repeating section

Hilary Stoupa — Fri, 03 Jan 2020 19:33:44 GMT

So - same error when you filled out the form using the controls directly bound to the data source? Can I see another screenshot?

Re: Submission error with repeating table within a repeating section

rlewis01 — Fri, 03 Jan 2020 19:26:36 GMT

unfortunately that didn't work, i have tried rebuilding the table and that didn't work. any other ideas?

Re: Submission error with repeating table within a repeating section

Hilary Stoupa — Fri, 03 Jan 2020 17:26:12 GMT

So - try this, just for an experiment. Insert the entire Date__Ward_information repeating node on your form as a repeating section with controls - just anywhere on there, you can easily delete it after testing. I think the issue is related to the binding in the view - you are inserting a new Date__Ward_information node, but not setting any values in it - you are setting values in one instance in your initial view, but not in your second view. I also think your data structure may not match your intent - it looks like the patient details info may need to be the parent of the aub aux data.

Re: Submission error with repeating table within a repeating section

Hilary Stoupa — Fri, 03 Jan 2020 17:20:52 GMT

Thanks - I grabbed it then deleted your post, since this template would have database connection info in it :)

Re: Submission error with repeating table within a repeating section

Hilary Stoupa — Fri, 03 Jan 2020 17:11:51 GMT

Could I see a copy of the template? You can also attach that under the options tab to a reply - I can delete it right after downloading it. :) I'm wondering about the repeating patient details section - is that on the form? It looks like there are multiple nested repeating nodes, so I'm wondering if it is something not displayed that is causing the issue.

Re: Submission error with repeating table within a repeating section

rlewis01 — Fri, 03 Jan 2020 17:00:43 GMT

this is the table set up

Re: Submission error with repeating table within a repeating section

rlewis01 — Fri, 03 Jan 2020 16:58:00 GMT

I cant see any blank rows that's whats so confusing.

Re: Submission error with repeating table within a repeating section

Hilary Stoupa — Fri, 03 Jan 2020 16:53:38 GMT

Hmmm. I'm wondering if when you add another section, the repeating table in it has a single blank row - perhaps that is what is causing the error? If it does, and you delete the row, does the submit succeed? You can also attach a screenshot of the form under the options tab in a reply (just save the screenshot as a .png or .jpeg first) so I can see what the form looks like when the submit fails...

Re: Submission error with repeating table within a repeating section

rlewis01 — Fri, 03 Jan 2020 16:42:46 GMT

Hi Hilary

thanks for you quick reply.

It says the form cannot be submitted because of an error

InfoPath cannot submit the form.
An error occurred while the form was being submitted.
Empty row cannot be inserted. Row must have at least one column value set.

Re: Submission error with repeating table within a repeating section

Hilary Stoupa — Fri, 03 Jan 2020 16:36:57 GMT

Hi - what does the error say? :)

Submission error with repeating table within a repeating section

rlewis01 — Fri, 03 Jan 2020 16:32:11 GMT

Hi wondering if anyone can help, i'm very new to InfoPath so don't fully understand everything.

I have designed a form for Audit purposes, I need to be able to have a common denominator of unit number and consultant linked to the audit data. The audit data needs to be able to add extra rows so I have created this using a repeating table within a repeating section.

I am able to submit the data with additional rows but as soon as I add another section it comes up with an error message and wont submit the data, really cant get my head around it.

(Unit number 1 / consultant 1 will submit but as soon as I add the second section unit number 2 / consultant 2 it errors)