Linking a subform

[Sean]

I have a form that contains a subform linked by two
fields from two tables that contain like data. I find
that clicking on the "link master fields" button in
design view calls up a box that lets me choose which
fields to link, and that I can link based on multiple
sets of fields. So, I select a second set of fields to
link (ones Access suggests), but upon returning to form
view, the field for the second link simply shows the name
of the main form. What am I doing wrong?

Sean

 

[Allen Browne]

Is the 2nd field called "Name"? If so, the form has a property called Name,
it is is interpreting your entry as the Name of the form. The solution will
be to rename the field.