Art
Open the form and make sure there is an ApplicationID and the rest of the fields.
Then open a new query and paste the SQL statement in the SQL view. Run the query. Be sure the database options for warnings are turned on.
When you run the query you should get warnings about a new record is about to be appended and then one telling you thta 1 record was appended. Either that or it will say the record could not be appended due to violations.
That should give you some idea of why it is failing.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> 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
>
Tidak ada komentar:
Posting Komentar