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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
Click to expand...

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
 
Back
Top