Submit Multiple Records based on one key possible?

[Dan von InfoPath]

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!

 

[Dan von InfoPath]

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"