Hello!
I'm having a bit of trouble getting my form to work correctly, any help from
one of you experts would be greatly appreciated.
The form essentially looks like this:
UserID
Date
Item
Item_Info
Additional_Info
I am trying to make Item and Item_Info a repeating group. UserID and Date
is the Primary Key.
I was trying to use one entered Primary Key, and a repeating group of Item
and Item_Info, to have multiple rows entered into a database on one submit.
I'll try and clarify.
UserID: Bob
Date: 1/1/01
Item: Hat
Item_Info: Big
Item: Shoe
Item_Info: Small
Additional_Info: Bob is smart
I would like that to enter into the database:
Bob 1/1/01 Hat Big
Bob 1/1/01 Shoe Small
To complicate matters further, I would like the "Additional Info" to be
entered with the Key, in a separate table. I can probably figure that part
out on my own if someone could assist me with the first part.
I do not want to see "UserID Date" repeated on the form over and over again.
Anyone know if this is possible to do? I feel like I am so close, but just
not quite getting it. Thanks in advance for the help!
Adam Harding - 13 Apr 2006 15:14 GMT
Dan
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
> Hello!
> I'm having a bit of trouble getting my form to work correctly, any help from
[quoted text clipped - 35 lines]
> Anyone know if this is possible to do? I feel like I am so close, but just
> not quite getting it. Thanks in advance for the help!