Subform within a subform

[Guest]

I have a database in Access, used to keep track of shipments and related
information.

Each record reflects an entire shipment, with a subform within the record to
reflect individual line items.

Within the subform for line items, I have another subform which is to keep
track of various information pertaining to that line item.

The trouble I am having is that the second subform does not clear to a blank
record each time you enter a new record on the first subform. Basically,
when you start record two of the subform for line items on the shipment, the
second subform retains the information from the last and does not update to a
blank record.

Is there a way to fix this?

 

[Guest]

Have you established a one-to-many relationship between Shipment and Line
Items, and another one-to-many between Line Items and Item Details? This is
typically done by establishing a relationship between the primary key on the
"one" side and a corresponding foreign key on the "many" side.

 

[Alex White MCDBA MCSE]

Hi

does it work when it is just the subform in the subform without the main
form?

e.g. for testing just test the two subforms on there own.