This is driving me nuts and I can't find anything where someone else has asked the same question. It can't be an unusual situation.
I have a Student entity and a Classes entity and both are bi-directional
Student<<-->>Classes
A Student can be assigned to many Classes and Classes can have many students When a Student drops out of a given class, I want to remove the link between the particular student and the class - but without deleting either the student or the class objects.
All my attempts have deleted either the student or the class object. How do I remove the relationship without removing the objects ?
Is it possible ? In the interim I guess I can create a new entity... a 2 field table that links student and class... 1 to 1... then just delete the individual records to break a link... sounds like a lot of extra overhead though for what's supposed to be relational