KevinS said:
Query will not let me add new records.
SELECT [Clearance Main Table].ACCYF, [Clearance Main Table].[Caregiver
Types], IntakeMain.KFName, IntakeMain.KLName, [Clearance Main
Table].[Child
Clearance], [Clearance Main Table].[FBI Clearance], [Clearance Main
Table].[CIU Clearance], [Clearance Main Table].[Criminal Clearance],
[Clearance Main Table].[Child Clearance Sent], [Clearance Main Table].[FBI
Clearance Sent], [Clearance Main Table].[CIU Clearance sent], [Clearance
Main
Table].[Criminal Clearance sent], [Clearance Main Table].[Child Clearance
Received], [Clearance Main Table].[FBI Clearance Received], [Clearance
Main
Table].[CIU Clearance Received], [Clearance Main Table].[Criminal
Clearance
Received], [Clearance Main Table].[In-Home]
FROM (IntakeChild INNER JOIN IntakeMain ON IntakeChild.CaseID =
IntakeMain.CaseID) INNER JOIN ([Clearance Main Table] INNER JOIN IntakeCYF
ON
[Clearance Main Table].ACCYF = IntakeCYF.ACCYF) ON (IntakeCYF.ACCYF =
IntakeChild.ACCYF) AND (IntakeCYF.CaseID = IntakeChild.CaseID) AND
(IntakeMain.CaseID = IntakeCYF.CaseID);
I really don't care to update the Access 97 database; I just want to pull
the key and the names from it so everything is consistent.
I don't understand that last sentence, but I suspect that your query may
fall into this category (from the help topic I mentioned, accessible online
via this link:
http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP051880011033):
+ Query based on three or more tables in which there is a
many-to-one-to-many relationship
The article gives this solution:
+ Though you can't update the data in the query directly, you can update
the data in a form or data access page based on the query if the form's
RecordsetType property is set to Dynaset (Inconsistent Updates).
So if this is the problem with your query, you maybe able to fix it on your
form by setting the form's RecordsetType property as described. The
RecordsetType property is on the Data tab of the form's property sheet in
Design View.
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)