Retrieveing previous records in a subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TCWC - 23 Jan 2005 21:45 GMT

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.

Reply to this Message

Tom Lake - 23 Jan 2005 22:03 GMT

>I have a main form (A) that has a subform (B) that has a subform (C)
>
[quoted text clipped - 4 lines]
> 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

Reply to this Message