Delete statement conflicted with COLUMN REFERENCE constraint

If I run this query on my database:
DELETE from products
WHERE id='30'
 
I get this error:
Delete statement conflicted with COLUMN REFERENCE constraint 'FK_product_g_prudu_OF582957'. The conflict occurred in database 'A4989_dev", table 'product_group_member', column 'product_id'.
 
 So somehow it's conflicting with the table product_group_member. I thought it was because there was no product_id 30 in that table, but using a number that appears in that table also doesn't work.  I get the same error if I try the query from another source, so I know it's not my SQL client in this case. Has anyone seen this before? Thanks!
Start Free Trial