What is the purpose of the Link Master and Child Fields?

G

Guest

I have a form which contains tabbed subForms, each subForm pulling data from
their respective tables. However, none of these forms talk to each other and
I don't really know the purpose of the Link Master Fields and Link Child
Fields sections. But i'm pretty sure this has something to do with it.

Can anyone shed any light or post me a link to where this is explained?
 
K

Keith Wilby

SparkyMark said:
I have a form which contains tabbed subForms, each subForm pulling data
from
their respective tables. However, none of these forms talk to each other
and
I don't really know the purpose of the Link Master Fields and Link Child
Fields sections. But i'm pretty sure this has something to do with it.

Can anyone shed any light or post me a link to where this is explained?

You should have a one-to-many relationship set up between the main form's
table and the sub's table. Set the Master to the main form's (table's)
primary key and the Child to the sub's (table's) foreign key. If you have a
relationship set then Access should suggest this link.

HTH - Keith.
www.keithwilby.com
 

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