T
Troy
table 1 - customer info
table 2 - customer inventory
I have a form with a two tab control. On first tab I have table 1. On the
second tab I have a subform with table 2. When I click the next record on
the form I'm on the same customer. I've noticed it copies the customer info
for each record on tab 2.
My relations are one to many from table 1 to table 2. Enforce Referential
Integrity and I have Cascade Delete Related Records checked.
table 2 - customer inventory
I have a form with a two tab control. On first tab I have table 1. On the
second tab I have a subform with table 2. When I click the next record on
the form I'm on the same customer. I've noticed it copies the customer info
for each record on tab 2.
My relations are one to many from table 1 to table 2. Enforce Referential
Integrity and I have Cascade Delete Related Records checked.