dchaley369

Self Join for Deleting Not Showing a Many to Many Join

Discussion created by dchaley369 on Sep 28, 2017
Latest reply on Sep 29, 2017 by dchaley369

I am stumped, so here goes.

I am working with a Self Join Relationship so I can delete records that have the same Customer ID but not the same Service ID. Simple enough done a few times.

 

But I am noticing that when I go to create the Self Join Table it is not showing a many to many relationship.

 

Therefore when I attempt to delete a Service Record the complete Customer account is deleted.

 

Any thoughts on why I am not getting the right relationship so we can delete  a single record and not a complete set.

 

I have tried multiple settings and I am stumped.

 

Thanks for the input, as always.

 

DC

Outcomes