Deleting rows in left joined table

Deleting rows in left joined table

ChrisKolliChrisKolli Posts: 28Questions: 8Answers: 0

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?

Answers

  • ChrisKolliChrisKolli Posts: 28Questions: 8Answers: 0

    Got it to work.
    Add ON DELETE CASCADE to your Datatabase has nothing to do with Editor

  • allanallan Posts: 54,703Questions: 1Answers: 8,556 Site admin

    That will do it :). Good to hear you got it to work.

    Allan

Sign In or Register to comment.