Could not delete from Specified Tables.!!!! 2

[Phooey]

I have two tables linked by a One to Many relationship with referential integrity and am trying to use a Delete Query to delete the records where the keys are the same.&nbsp;&nbsp;Every time I try to delete the records using the query, I receive the error message, <b><font color=red>Could not delete from specified tables</font></b>.&nbsp;&nbsp;The query <b>UniqueRecords</b> property is set to yes, but still it comes up with the error message.<br><br>Can anyone shed some light on this problem..?

 

[RoyVidar]

Hi!<br><br>One tip would be to ensure that you have selected all the fields in both tables in your query, another to change the relationship (check the Cascade Delete checkbox in the relationships window for this relationship). Whith this choice checked, you can delete from the base table (on the one-side of the relationship), which in term will delete the related records.<br><br><br><br>

 

[Phooey]

Another part of this, I find, is to look in the Query properties to make sure that the Unique Records property is &quot;Yes&quot;.