Newbie Questions

Re: Add multiple values to acess database using infopath form

Odrec — Wed, 03 Jun 2009 15:56:38 GMT

Hi, thank you very much for your help. I`m going to try that.

Re: Add multiple values to acess database using infopath form

Patrick Halstead — Mon, 01 Jun 2009 07:30:01 GMT

Hi Odrec,

To get a repeating table, go to the data source taskpane, select the myFields or root group node. Click on Add a Field or Group (at the bottom of the taskpane). Select group for the type add check the box to make it repeating. You can then add regular data nodes underneath this and they will repeat. If you drag the repeating group to your form, you can have the option of choosing a table in which case the fields underneath the group node become columns.

Hope this helps,

Add multiple values to acess database using infopath form

Odrec — Tue, 26 May 2009 18:12:36 GMT

Hi, I´ve been looking for a solution for this but I can´t seem to find exactly how to do it. I have a very simple database in access and I want to fill a table´s values using an infopath form. I´ve managed to add all the fields except those which need to be selected using checkboxes. With checkboxes I need the possibility of multiple values to be added to one field on the access table(separated by commas or whatever). I tried adding several checkboxes bound to the same field but once I check one the others are unchecked. I tried adding a multi-select list box but it won't allow me and tells me that I need a repeating table for that but I don´t know what that means and I think that what I need to do is much simpler than that.

Thanks in advance for any help