Can I ask why you think you need to store first and last names for the same person in multiple tables? I would think this information would be stored in one record in one table with primary and foreign key values used to pull the information as needed.
If you really think you need duplicated data in your tables, you might want to check if tblApplicant might allow zero-length-strings while tblApplicationHouseHold doesn't.
Duane Hookom
MS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: dbalorenzini@yahoo.com
Date: Tue, 13 Sep 2011 16:48:39 +0000
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]
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Tidak ada komentar:
Posting Komentar