Subform linked to another subform

S

Scott

I have a form with three subforms in datasheet view. The form
contains data from a Customer table. The first subform contains data
from a Model table that is linked to the Customer form. The second
subform contains data from an Interface table that is linked to the
Model subform. The third subform contains data from a Service table
that is also linked to the Model subform. When I scroll through the
Customer form, the Model subform scrolls accordingly. When I scroll
through the Model subform, the Interface subform scrolls accordingly;
however, the Interface subform always displays the record for the
first record in the Model subform. The "Link Master Fields" and "Link
Child Fields" are the same for both the Interface subform and Service
subform.

The relationship for the tables are as follows:
Customer - CustomerID
Model - CustomerID, ModelID
Interface - ModelID, InterfaceID
Service - ModelID, ServiceID

Can someone point out my blind spot?

My humble regards,
Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top