Creating separate rows in database - InfoPath Dev
in

InfoPath Dev

Creating separate rows in database

Last post 08-31-2009 12:06 PM by heath3106. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 08-21-2009 07:00 AM

    Creating separate rows in database

    I am designing a form that will be stored on a SharePoint site but will submit to an access database. I have several separate sections in the form. When submitted initially, I want each separate section to create it's own row in the database but using the same form id assigned by the database. How would I accomplish this?

     

    thanks.

  • 08-26-2009 03:19 PM In reply to

    Re: Creating separate rows in database

    To submit to an Access database, your form needs to be based off a database (or you'll need a custom web service or custom code). You'll need to define your table relationships appropriately in the database and also in the form when you create it. If the 'id' is an auto id field in Access, and your relationships are defined correctly, the id should correctly populate through all the tables on submit.

    Hilary Stoupa

  • 08-31-2009 12:06 PM In reply to

    Re: Creating separate rows in database

    I am a newbie to code. Could you point me to an example of what I need?

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