Retrieveing previous records in a subform

[Guest]

I have a main form (A) that has a subform (B) that has a subform (C)

When I open subform (C) it does display data that I already entered. The
main form (A) and the subform (B) does display prevousily entered data.

I tried to make the relationship a one-to-many between the primary key in
subform (B) and subform (C) but it will only allow a one to one relationship.

All help is appreciated.

 

[Tom Lake]

I have a main form (A) that has a subform (B) that has a subform (C)

When I open subform (C) it does display data that I already entered. The
main form (A) and the subform (B) does display prevousily entered data.

I tried to make the relationship a one-to-many between the primary key in
subform (B) and subform (C) but it will only allow a one to one
relationship.

The key should NOT be the primary key in subform (C), although it should be
a non-exclusive index.

Example: CustID is primary key in main table, but it's only one index of
Orders table since one customer may have multiple orders.

Tom Lake