Athenkosi Monakali

Hi Guys

Can I be assisted here?


What I want to is to delete Row 2 which is the same as in Row 1. When you look at the ComplaintNumber you will notice there is a duplicate of Complaint. But when i try to delete the duplicate it complaints about the child table which is in CASE table. Even there I can delete because even the Child Table has a relationship with other tables in the same Database.

I also posted this question on Stack Overflow; https://stackoverflow.com/questions/58952607/trying-to-delete-duplicates-from-tables-with-relationship

Thanks in advance for your responses.

Kind regards
Attie