LinkMasterFields property error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have worked for 3 days on this error:

"The LinkMasterFields property has produced this
error: 'The object doesn't contain the automation object:
Names'

I am using Access2002 on XP. 2002 file format. I have
these tables:

Names
Addresses
NamesAndAddresses

Names - First, Middle, Last
Addresses - The usual fields
NamesAndAddresses - linking table to provide the many-to-
many relationship.

This setup is used because I have records for each member
of a family in Names and they may all use the same
address. Plus, a child of divorced parents may have 2
addresses. Thus the many-to-many relation.

I have a main form that's record source is a query that
selects all fields from the Names table. I have a sub
form that shows the addresses through the linking table.
While showing each name record the address in the subform
updates correctly. But, I cannot enter a new address for
a particular record in the subform without getting the
error above.

I also have a phones and emails table with NamesAndPhones
and NamesAndEmails linking tables respectively. I have
subforms for phones and subform for emails on this same
master form and they exhibit the same error!

I do have the primary key ID, from Names as the
MasterField and the foreign key, ID, from the subform
query as ChildField.

I have checked books, I have looked at the Northwinds
subforms example, and I am doing it just like they say.

I just can't figure it out. I don't understand what piece
is missing.

Any help much appreciated

-Martin
 
Sounds as if there may be a typo in the MasterLink field where you've typed
the name of the primay key field's name. Post what you have there. Also post
the form's recordsource query's SQL statement.
 
Back
Top