Sorry, for asking this simple procedure.  How is this done?

it is to add the nonexisting i.e. new cases without having to add them again.  i have succedded by including an identity field in table 1.  Thanks.

Allan.

Thanks Nashi, though i was unable to control the appending such that when an insertion as been made then there should be an insertion for the same records but for...

Phil Parkin: How do i do it in a set-based procedure?  take into account that testscreen table has other variable apart from the three set of multi-column used to select...

with commenting of the following two lines the code runs very well

--EXEC sp_executesql @nvchCommand

--PRINT @nvchCommand

Phil it is true i selecting dups then deleting the extra cases. i.e. if they are...

this is what i used and it work so well...

create trigger tr_delete_testscreen

on testscreen

after delete

as

begin

insert del_screen

(RecID, InterviewPK, InterviewerCode, InterviewDate, DSSID, HouseholdID, AgeYrMo, AgeDays, SelfProxy, ProxyType, ProxyOther, ProxyReason,

                      OtherReason, DeathDate,...

It is an ODBC link which i have successfully managed to modified the struture from the SQL - EM and then refreshed the link with the access and it has...

It should be a datetime format and it has work well.Thanks journeyman.  great day.

allan.

Thanks kenneth, this has worked satisfactorily.  Once again it is greate to be in this forum.

Allan.

Thanks, Ryan.  it has worked very well.

Allan.

Thanks Kenneth,  it has worked.  i am greatful to ur advice.Great day.

Thanks it works so nicely though it didn't remove the NULL fields.