LinkMaster Fields error message

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

Guest

I have a main form which shows a family name, plus an unbound combo box that
allows a name to be searched.

In the sub-form I have all of the contact data related to that family,
including name, phone, e-mail, etc.

When I try to enter new data in the form, I get the following message:

"The LinkMaster property fields setting has produced this error: The object
doesn't contain the animation object "FamilyContactInfo."

HELP!
 
I figured it out - for some reason the sub form wasn't "pointing" to the
query, but rather another table.

However, I can now add one initial new contact for a family, but now have
two more problems:
1) I can't add more than one row in the datasheet view sub-form per family.
I will have multiple contacts for one family.
2) In families where I already have more than one contact from entering
directly in the table, it now shows the family name twice in the unbound
control that I use to find a family name.

HELP! Again. Thank you.
 
However, I can now add one initial new contact for a family, but now
have two more problems:
1) I can't add more than one row in the datasheet view sub-form per
family. I will have multiple contacts for one family.

It sounds like you are using FamilyId as a primary key or unique index in
your contacts table. The correct key for contacts would probably be
something like FamilyID plus FirstName, LastName and MiddleInitial. (Ok-
this is a huge area of debate but you need to find some field or combination
of fields that makes the record for "John Smith" unique.)
2) In families where I already have more than one contact from
entering directly in the table, it now shows the family name twice in
the unbound control that I use to find a family name.

In the rowsource query of your combo you either need to remove the contacts
table, or use grouping to restrict the data to one row per family. Unless
you really need to see something from contacts, just drop that table from
the query.
 
Back
Top