Submit Multiple Records based on one key possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan von InfoPath - 17 May 2006 17:46 GMT

Hello,
I would like to have one form, submit multiple records, all with the same
primary key. I'm having trouble getting this to work though.

I don't want to have to see the primary key for every record, I would like
it to be entered at the top of the form, only once.

It seems like I would be able to do this with references, but I'm not sure
if this can be done in InfoPath.

Essentially I need a user to Enter this Information
{
Name
Date

Data 1
Data 2
Data 3
}

And in the database it will put:
Name Date Data 1
Name Date Data 2
Name Date Data 3

Are there any ways to do this? Thanks!

Reply to this Message

Dan von InfoPath - 17 May 2006 18:06 GMT

I actually found the answer from Adam Harding:

"Essential if you want to repeat back to a database, the database has to have
more than one table with the tables relating on a one-to-many basis. For
example

* is primary key
# is the field that links to the primary key on a one-to-many relationship
@ is the field that links to the primary key on a one-to-one basis

Table1
User ID*
Date

Table2
Item
Item Info
User ID#

Table3
Additional Info
User ID@

Hence you can have multiple items per user but only one additional comment.

Try that and it will work fine for both your requirements.

Cheers Adam"

Reply to this Message