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.