Its an archive table. Those properties are the same in both tables.
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: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Tuesday, September 13, 2011 1:55 PM
Subject: RE: [MS_AccessPros] Append record not working
Art,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 HookomMS Access MVPTo: MS_Access_Professionals@yahoogroups.comFrom: dbalorenzini@yahoo.comDate: Tue, 13 Sep 2011 16:48:39 +0000Subject: [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.ApplicationIDFROM tblApplicant INNER JOIN tblApplication ON
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar