If I run this to a datasheet view and fill in the applicantID when prompted it returns the appropriate record.
With warm regards,
Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
1316 E. 7th Street
Sioux Falls, SD 57103
SQL Server Development
Database Adminstration Services
Microsoft Access Development
Grant Writing TA Services
IT Assessment Services
Software Application Training
From: Art <dbalorenzini@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, September 13, 2011 11:48 AM
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
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar