R
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?
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?