Retrieveing previous records in a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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
 
Back
Top