delete umatched records

[Guest]

I have two tables: checks and vendors
Need to purge vendor table of any vendors who do not have checks writtent to
them.

Made query: *Vendor(from) and Checks.Vendor (where vendor 'Is Null')
Can view in database and see records to delete. Cannot run the query.
Receive message that records cannot be deleted.

Tried to change relationship to enforce referential integrity and cascade on
delete but it would not allow this change.

Any ideas? Please reply to (e-mail address removed)
Thank you in advance.

 

[Guest]

try On the properties of the query change the UniqueRecords to true

 

[Guest]

also dont display the field that you filter on the null, remark not to display.