How to delete records which are connected to other tables?

[mdburhan3]

Hello Everyone

I have 3 different tables like this

When i delete the existing “shop” then that deleted shop’s “shop_timings” & its “products” are not getting deleted ?
instead it shows like this

How can i remove all this connected stuff | (Deleted thing) ?

Thanks for your help ?

[mikeloc]

Hi there, @mdburhan3… you need to have separate workflow actions to delete the things that are associated with the shop before you delete the shop itself. As you have already found out, deleting just the shop does not delete any of the things that are associated with it. Again, you need to set up specific workflow actions/steps to delete those things.

Hope this helps.

Best…
Mike

[mdburhan3]

@mikeloc
Yes i agree…
Thanks

But for existing records how can i access this “deleted thing”
"Do a search for Products : created by deleted thing" seems not possible (I don’t want to do it manually from database because they are in thousands, Any simple way ?)

[mikeloc]

Ah, I misunderstood the question… sorry about that. You should be able to do a search for things in that data type where Created By isn't in Search for Users (with no constraints on the search for users).

[mdburhan3]

Thanks a lot @mikeloc
It works…

For future readers this is what i did…