AnsweredAssumed Answered

Finding Customer NOT related to other tables

Question asked by Tom_Droz on Oct 20, 2015
Latest reply on Oct 21, 2015 by APIcoder

Hi all

 

I have a customer table that several other tables can use.  When they associate it, the related table has an entry of the primary key from customers.  The customer table has not entry showing that it is being used in various tables.

 

From time to time I want to delete a customer but need to make sure that are not being used in the 1/2 dozen tables that might be in.

 

Is there an easy way to see, before deletion, if any relationships exist?

 

Thanks for any insight

Tom

Outcomes