Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / April 2006

Tip: Looking for answers? Try searching our database.

Repeating Section/Database Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dan von InfoPath - 12 Apr 2006 15:28 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.