Forms with Subforms used for updating data

[Guest]

I have built a master form which queries contractor names. This form is link
to two subforms which are pulled from two tables which are related:
1) Subform has all of the contact info for the companies
2) Subform two has what they specialize in.

These forms were built so the secretary can pull up companies and update
their data.

When I use my drop-down to choose a company on the Master form, it pulls up
the data for the two subforms fine. When I try to update company contact info
and specializing data the first time, it also works fine.
Again when I use the drop-down and pull another company from the list, the
two sub-forms pull data fine. However, when I try to update the contact and
specializing data in the two sub-forms, I get this message: "The record can
not be deleted or change because table 'Contractors Specialties' includes
related records.'

Can this form not be used to update information if the tables are related?
Please help me fix this issue.

With best regards,
Tamara

 

[pietlinden]

are you trying to change the primary key? What field are you using to
join the contractor table to the child tables? Do you have Cascading
updates/Deletes turned on?

 

[Guest]

The tables are as follows and they are joined by these fields:

Contractor: Primary Key is "CompanyName"
Contractor Specialties: Primary Key is "Firm"

My Master form has a drop down which lists the CompanyName which comes from
a select query which is linked to the Contractor table. It has the parent
field CompanyName.

The 1st subform shows the information from the Contractor table and it has a
child field CompanyName.

The 2nd subform shows the information fo the Contractor Specialties and it
has a child field Firm.

I am sorry, I do not know what you mean by "Do you have Cascading
updates/Deletes turned on?"

Thank you for your help.
Tamara