I have the following append query that keep reporting a violation error:
INSERT INTO tblApplicationHousehold ( FirstName, MiddleName, LastName, MaidenName, ApplicationID )
SELECT tblApplicant.FirstName, tblApplicant.MiddleName, tblApplicant.LastName, tblApplicant.MaidenName, tblApplication.ApplicationID
FROM tblApplicant INNER JOIN tblApplication ON tblApplicant.ApplicantID = tblApplication.ApplicantID
WHERE (((tblApplication.ApplicationID)=[Forms]![Application Details]![ApplicationID]));
It's not inserting the record into the tblApplicatioHousehold record. I first I though it was a PK issue but the PK for the table is HouseholdID so I am a bit confused.
Thanks,
Art
Sioux Falls, SD
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar