>Hi everyone,
>
>I have a parent (tableA - Media) with a child (tableB - media# = primary key of tableA) AND a parent (tableC - Document) with a child (TableB - Document# = primary key of tableC)
>
>In my case, when I delete a record in (tableA - Media), I should delete all references in (tableB - Media#/Document#) AND (tableC - Document).
>
>How do I setup RI designer (delete) when I delete a record in (tableA - Media)?
>
>Thanks
>
>Pierre
Why would you want to do this? Let me understand if I have your relationships correct. Table holds a foreign key to both tables A and C. So I could say that A is like a customers table, and C is like a products table, and B is like an orders table, that specifies which customer bought which product.
You are saying that when you delete a customer, you want to delete the product? I would think you only wanted to delete the order... I apologize if I am confused.
Erik Moore
Clientelligence