subform continuous form not display records

[mdavid]

Hi, I have a main form with a subform. the main form displays the record from the single record table but the subform - continuous form - is not displaying any records from the many records table. Can you please suggest a check list of what I need to check so that my form and subform are synchronized and both display their records.

Thanks for any help
David

[June7]

If tables have the primary and foreign key fields and Master/Child Links properties are properly set then the records should synchronize.

[mdavid]

Thanks for this.
Excuse my ignorance but is a foreign key defined or is it defined by it's use? Can you give me an example of the relationship between a form and subform.

Thanks
David

[June7]

Main form bound to table Orders. Subform bound to table OrderDetails.

Primary key of Orders is saved as foreign key in OrderDetails.

The is basic relational database principle.

[mdavid]

Thanks June,
So in this case Foreign key is on the many side and primary key is the single side. I don't define it it's defined by its use, is that correct?

While we're here I have another question - or 2, can I put a Split Form in a tab control page. Is a Split Form only a single view with datasheet view or could it be single with continuous form.

Thanks for your time and patience
David

[June7]

Split form is Single view in one section and Datasheet in other.

Apparently a split form cannot be a subform, on or off Tab control.

[ssanfu]

Maybe easier to get with pictures............

From Post #3:

Excuse my ignorance but is a foreign key defined or is it defined by it's use?

You define a field as a foreign key

Can you give me an example of the relationship between a form and subform.

June used "Orders/OrderDetails", I have "Students/StudentsTakingCourses". Same idea....
Main form/Sub form: