Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / August 2006

Tip: Looking for answers? Try searching our database.

Forms with Subforms used for updating data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tv - 13 Aug 2006 20:03 GMT
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@hotmail.com - 15 Aug 2006 08:26 GMT
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?
tv - 16 Aug 2006 01:13 GMT
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

Signature

tv

> 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.