Art,
That error took me a long time to get to understand. Is it erroring for sure on the key violation or another violation?
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art
Sent: Tuesday, September 13, 2011 9:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Append record not working
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
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Tidak ada komentar:
Posting Komentar