Deleting rows in left joined table
Deleting rows in left joined table
ChrisKolli
Posts: 28Questions: 8Answers: 0
in Editor
Hey hey
So the situation at the moment is as follows.
I have two tables left joined together and everything is nice except that removing rows does not do what i want it to.
Create and edit work fine but remove only removes the data in the main table eben though ajax posts the joined data to be deleted too.
I found this post: Prevent row deletion on joined tables
So I guess it is editors expected behaviour.
How can i work around this? What code would you need to help me?
This discussion has been closed.
Answers
Got it to work.
Add ON DELETE CASCADE to your Datatabase has nothing to do with Editor
That will do it
. Good to hear you got it to work.
Allan