LinkMasterFields property error

[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

 

[Ken Snell]

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.