Multiple tables on 1 form

[pas123]

I have 6 tables that have 1 to many relationships.
I would like to have all 6 tables on 1 form for data entry.
When I use the “Form wizard” and select the tables it wants to group the last 3 tables in 1 subform and it won’t let me add records to the last 2 tables. Same thing happens when I create a query and run the form wizard selecting the query.

I know I’m doing something wrong but I can’t see it……….

Thanks
Paul

Here's an add on question:

When the form wizard adds a subform to a subform the link child and master are filled out and the form updates. But when I add another subform and set the links it will not update.
Example:
form Book has text fiels and 2 sub forms "Chapter" and "Section" subform section child link is ChapterID, master link is [Chapter Subform].Form![ChapterID] --- This updates as expected.

I create a new subform "para" based on a table and set the Child link as SectID, master link [SectionID].Form![Section Subform].Form![SectionID] --- Will not update the subform "para" when the next record in subform "section" is selected.

Any ideas would be great......

 

[pas123]

Pat,

Here's the data structure:
AC20-11, 1, Chapter 1 Title, a, Section a Title, i, Paragraph i text, 1, SubParagraph 1 Text, A, SubSubParagraph A Text

I have tables setup like this:
tblAC
(PK)ACID
ACNum
ACTilte

tblChapter
(PK)ChaptID
(FK)ACID
Chapter
ChapterTilte

tblSection
(PK)SectID
(FK)ChaptID
Section
SectionTilte

tblParagraph
(PK)ParaID
(FK)SectID
Paragraph
ParagraphText

tblSubParagraph
(PK)SubParaID
(FK)ParaID
SubPara
SubParaText

tblSubSubPara
(PK)SusSubParaID
SubSubPara
SubSubParaText

AC contains many Chapters
Chapter contains many Sections
Section contains many Paragraphs
Paragraph contains many SubParagraphs
SubParagraph contains many SubSubParagraphs

I want to be able to enter all the chapters,sections,and parargraphs for each AC with one form.

Since I can't get it work does it mean I have set it wrong?

Thanks
Paul