Design Form with Linking Table

N

Nanette

I've created several tables because of a many to many relationship:

Cabinets
CabinetDetails
LinkCabAndParts
Parts
PartDetails

I've been trying to create a form that will have several of the fields from
all of the tables using sub-forms. I created an initial Cabinet form with a
subform CabinetDetails, added a LinkCabAndParts subform just to see if things
are working correctly, and then added another subform called Parts with its
own subform PartDetails. It seems to be working even though the Link Child
Field on the Parts subform is connected to the Cabinet form instead of the
LinkCabAndParts subform.

Am I doing this correctly? I'm worried that the LinkCabAndParts table
connection is not being used. Is it possible or necessary to get the subform
Parts Linked to the LinkCabAndParts subform?

I tried changing the Link Child/Link Master fields, but it would not allow
me to use anything but the Cabinet Form.
 

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

Similar Threads

Linking Table in Forms 4
Adding data to MS Access from csv file 0
Form and subform - timing of event triggering 4
Subform linked to form - ID number to come into subform? 1
subform within subform On Main for Child master link question 2
Records in subform do not change when record in main form changes 0
Form/SubForm error while reference the object 1
Performance question 5

Top