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 / December 2005

Tip: Looking for answers? Try searching our database.

Repeating Section Difficulties When Connecting to Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Christian Andersen - 09 Dec 2005 20:43 GMT
I have a database that I have created for tracking issues within my company.
It's an Access database (2003) containing 2 tables. The first table contains
general information about a particular issue. The second table contains the
detailed notes (there are several) for each issue. I opened Infopath and
created a new form using my Access database. I first selected the general
information table and then used the 'Add...' button to select the the
detailed notes table. Their relationship is through an 'IssueID' field. I
then choose to create the query view first. The query view work fine. When I
go to create the data view, I insert a repeating section that contains the
general information fields. Then I try to nest another repeating section
within that one to show all of the detailed notes for that issue I receive a
message telling me that I need to cannot bind to a group or field that is not
repeating.
 I have tried various ways of nesting the detailed notes to no avail. I
have also looked through the Infopath tutorials and forums and didn't seem to
find an answer. I would be very appreciative if someone can give me a hand or
at least point me in the right direction.
Adam Harding - 13 Dec 2005 08:13 GMT
Christian

If i am reading you right you have this setup

Form
      -Repeating Section
                                 -Repeating Section

on your form.

So you have the Form, with a repeating section on and you are looking to
insert a nested repeating section within the repeating section.

If this is the case then your database needs to have 3 tables; 'the form'
table, 'the first repeating section' table, and finally, 'the second nested
repeataing section' table.  This is because your datasource is in a
one-to-many relationship.

However, your queryfields are not set in any relationship but a flat
structure, hence your query form works, but your data form does not.

Hoep this helps

Cheers Adam

> I have a database that I have created for tracking issues within my company.
> It's an Access database (2003) containing 2 tables. The first table contains
[quoted text clipped - 13 lines]
> find an answer. I would be very appreciative if someone can give me a hand or
> at least point me in the right direction.
 
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.