IS this code correct?

[Jen0dorf]

HI



been going round in circles here

Have a table with an auto number key called tblmemorial and the key field is MemorialID

HAve another table called tbljoin which has a field called fkMemorialID

Both tables have two identical fields GraveNo and Plot

So I want to copy the field Memorial ID to the field fkMemorialID so usingthe query wizard created

UPDATE tblMemorial INNER JOIN tblJoin ON tblMemorial.MemorialID = tblJoin.fkMemorialId SET tblJoin.fkMemorialId = [tblMemorial].[MemorialID]
WHERE (("where [tblMemorial].[Plot]"=[tblJoin].[Plot] And [tblMemorial].[GraveNo]=[tblJoin].[GraveNo]));

When I run it I get the message you are about to update 0 rows can someone please advise?

thanks

Ian

[CJ_London]

having joined

ON tblMemorial.MemorialID = tblJoin.fkMemorialId

you can't then change the values

SET tblJoin.fkMemorialId = [tblMemorial].[MemorialID]

And I've never seen a sql construct like this

WHERE (("where [tblMemorial].[Plot]"=[tblJoin].[Plot] And [tblMemorial].[GraveNo]=[tblJoin].[GraveNo]));

try this instead

UPDATE tblMemorial INNER JOIN tblJoin ON tblMemorial.Plot=tblJoin.Plot And tblMemorial.GraveNo=tblJoin.GraveNo SET tblJoin.fkMemorialId = tblMemorial.MemorialID