sub-Subform trouble

[tjones]

I have been working on a subform within a subform on a form.

I have used this same subform directly on form and it works, but using it as a third layer is causing problems. It works but will not display all records only the first record entered. All records are displayed in the TribalInfo table.

I have attached the design view and form view of both the Course form which works correctly and displays all records and the Demographic form which will only display the first record.

I have also attached both queries. Any help would be greatly appreciated.

forms: queries:

 

[jdraw]

??? Here is a video tutorial that may be useful - has helped me from time to time.
http://www.datapigtechnologies.com/flashfiles/subform2.html

 

[tjones]

I know that my queries are working as the information is stored in the table, it just will not display all records. I have attached the table so you can see it should be working.

As you can see the first two lines are for the same ID,

Even when working only with the form and first subform it will not display all records, only the first.

I have the forms in each other, just can't figure out why when using the same setup it works for courses but not tribal.

 

[tjones]

Finally managed to figure it out. It was linking the wrong fields in the Child/Master. Instead of linking the Student ID or 790ID which is the main identifier in each table and form, it was linking tribal ID