in our VServer database we've several tables that are linked mostly 1:M. Now when we delete a "master" record all connected records get also deleted. After the detail records are deleted it seems the "links" are still intact. Is this intended to behave like that or shouldn't the links themself also get deleted when deleting cascaded records?
We use ADK .NET with VServer connection. This can also be tested in Valentina Studio when linking some records of different tables then delete a master record. Then try to create new records and link them. You'll get an error telling that the records are already linked.
Any suggestions on this?