Data Connections

Re: Creating separate rows in database

heath3106 — Mon, 31 Aug 2009 19:06:27 GMT

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

Re: Creating separate rows in database

Hilary Stoupa — Wed, 26 Aug 2009 22:19:27 GMT

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.

Creating separate rows in database

heath3106 — Fri, 21 Aug 2009 14:00:45 GMT

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.