Add multiple values to acess database using infopath form - InfoPath Dev
in

InfoPath Dev

Add multiple values to acess database using infopath form

Last post 06-03-2009 08:56 AM by Odrec. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 05-26-2009 11:12 AM

    • Odrec
    • Not Ranked
    • Joined on 05-26-2009
    • Posts 2

    Add multiple values to acess database using infopath form

     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

    Filed under:
  • 06-01-2009 12:30 AM In reply to

    Re: Add multiple values to acess database using infopath form

    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,

    Patrick Halstead
    Project Manager at Qdabra
  • 06-03-2009 08:56 AM In reply to

    • Odrec
    • Not Ranked
    • Joined on 05-26-2009
    • Posts 2

    Re: Add multiple values to acess database using infopath form

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

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.