Update query rules error

[Jen0dorf]

Hi



I have two tables that have records with duplicate fields

I created a query to list the duplicates - 3920 in total

SELECT tblDeceased.Inscription, tblMemorial.Inscription, tblDeceased.Forenames, tblDeceased.Mlink, tblMemorial.Mlink
FROM tblMemorial INNER JOIN (tblDeceased INNER JOIN tblJoin ON tblDeceased.GraveID = tblJoin.fkGraveID) ON tblMemorial.MemorialID = tblJoin.fkMemorialId
WHERE (((tblDeceased.Inscription)=[tblMemorial]![Inscription]));

I then changed it to an update query

UPDATE tblMemorial INNER JOIN (tblDeceased INNER JOIN tblJoin ON tblDeceased.GraveID = tblJoin.fkGraveID) ON tblMemorial.MemorialID = tblJoin.fkMemorialId SET tblDeceased.Inscription = ""
WHERE (((tblDeceased.Inscription)=[tblMemorial]![Inscription]));

But the update does not work due to violation rules

I'm assuming it's because I'm updating a reference field?

So how do I do this

thanks

Ian

[ranman256]

you can update reference fields, but you cannot update autonums.
nor fields if a rule is set.
and some joins cannot update.

[Jen0dorf]

Hi

thanks for the hint , it appears to be the join
so I re madethe query and it worked

cheers

Ian