All records not displaying in form

[Richard Mumma]

I have created what I thought was a simple database. I have a main table
with three detail table. Each is linked to the main table throught a
one-to-many relationship.
I have created a form on the main table with three subforms set on a tab
sheet. Each was created using the subform wizard. Here is my problems.
The main table has 8 records when viewed in "Datasheet View". When these
records are viewed in the Form two things happen.

1. Not all of the records table are visible
2. Multible occurances appears for single records in the main table. (it
seems to be assocated with the number of records in one detail table.

I have removed the relations and re-established. I have removed the
subforms and re-created and nothing seems to work.
Can anyone help?

 

[Klatuu]

What is the record source for your main form?
If it is a query that includes the other tables, then you will get the
results you are experiencing.
Your main form's recordset should be based on only the main table. The
subforms should each be based on one of the 3 other tables. Then you use
the Link Master Field(s) and Link Child Field(s) properties of the subform
controls to show the records in the child tables associated with each master
table record.

 

[Richard Mumma]

The main form is based on a single table
each detail table is linked via a commond filed in all tables
each subform is based on one of the linked detail tables

I set up a relationship between the master and each details table before
creating the subforms using th wizard.

 

[Richard Mumma]

OK, I found the problem. Somehow I had built a query between the main table
and one of the details. I noticed the "Main Form" was listed in the details
table group with the subform and was wondering why. I was checking the Main
Form properties and found the query. Once removed, the problem was solved.

 

[Klatuu]

Very good. That is exactly what I expected.

OK, I found the problem. Somehow I had built a query between the main
table
and one of the details. I noticed the "Main Form" was listed in the
details
table group with the subform and was wondering why. I was checking the
Main
Form properties and found the query. Once removed, the problem was
solved.