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.
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.