Master Record delete when I delete portal row record

[Sheju Sathyanesan]

Why the master record delete if I delete a record in the portal... Please help. I have checked all the options properly.. It has been working, suddenly it stopped working and deleting the master record also...

[Wim Decorte]

Can you post a screenshot of the script where this happens?

[Sheju Sathyanesan]

Here is my file.. Go to donations and create new master Record // add a breakdown and delete... it deletes all... thank you so much

AGG-8.fmp12.zip

[bruceR]

No mystery: one of the relationships is set up to delete invoices when an invoice item is deleted.

[Sheju Sathyanesan]

Awesome... Ten thousand words of appreciation... it was killing me.... You saved me. thank you so much... it is working now

[Rick Whitelaw]

I would venture that most developers have made this mistake! Child Table records set to delete Parent Table records. In some cases, like mine, I had made the mistake early on. Then I deleted a child record and it deleted the parent record which then deleted hundreds of payroll entries. Always backup . . .

[webko]

Ya, been there, done that.

I (in about 99/100 cases) simply do not allow relationships to perform deletes these days....