subform not showing all records

J

Judah

I have a subform that allows me to add multiple records associated with
the parent record, but it will not show more than one once I leave the
record. When I return to the record it only shows the first of the
records in the subform. These records are stored in the table
associated with the subform.
please help,
-Judah
 
J

John Vinson

I have a subform that allows me to add multiple records associated with
the parent record, but it will not show more than one once I leave the
record. When I return to the record it only shows the first of the
records in the subform. These records are stored in the table
associated with the subform.
please help,
-Judah
Click to expand...

If the Subform's Data Entry property is set to Yes - switch it to No.

Otherwise, please post the Recordsource property of the subform, and
its Master and Child Link Fields. Someone should be able to figure out
why it's not displaying what you expect.

John W. Vinson[MVP]
 
J

Judah

The data entry property is set to no already.
The record source is "Participation subform" which is the name of the
table. and The Master and Child Link fields are ID. I also want to
note that when I view the relationships window, it shows no
relationship between the two fields - could that be the problem, if so,
should I create a relationship between the two? If so, I have not been
able to figure out how to create a one-to-many relationship in the
relationships window.
Thanks so much for your advice.
-Judah
 
T

Tom Lake

Judah said:
The data entry property is set to no already.
The record source is "Participation subform" which is the name of the
table. and The Master and Child Link fields are ID. I also want to
note that when I view the relationships window, it shows no
relationship between the two fields - could that be the problem, if so,
should I create a relationship between the two? If so, I have not been
able to figure out how to create a one-to-many relationship in the
relationships window.
Click to expand...

In order to create a one-to many relationship, the linking index must be the
primary index in the one table and a non-primary index in the many table.
To create the relationship, add the two tables to the Relationships window.
Now click on and drag the primary index field in the one table to the index
field of the many table and release the mouse button. A dialog will come up
asking about the relationship. When done entering options, click on the
Create button and the relationship will be formed. You can tell it's
one-to-many because there is a little "1" by the one table side of the arrow
and a tiny "lazy eight" infinity sign near the many side of the table
signifying that there can be many entries in this table for each one in the
"one" table.

Tom Lake
 
Top