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.