Yes, I agree but I just added a workflow deleting Current products. I did not understand. That is why I asked the terms deleting in cascade all items that is related to the thing being deleted.
So if your User data type has a field that is a list of Products data type and you delete a product - it will be deleted from the list of Products within the User. But the User will not be deleted until you have a corresponding WF action.
Have you checked you app DB to be sure that User was really deleted?
What I mean is that if you are testing adding to favourites without logging user in - you are working with temporary user (which is active for 72 hours). So temporary user is added to the list favorit_by. In 3 days the temp user is deleted from Bubble (if I’m not mistaken, haven’t tested it for a long time). You could miss the moment when user has been auto deleted and while deleting a Product you’ve suddenly noticed that the User is not in the DB anymore.
I have fixed the problem, since I was trying to delete an item from a repeating group but I am do not know what happened.
I have a relationship of Product ---> Order-product, but the RG is Order-product in which I was displaying the order-product details as well as its product relationship fields in the same current cell.
And when I added to delete that current cell which is Current Page Product the user was deleted.
I have tested creating new users as well and all of them (logged) are being deleted as well. I could not find what was the problem but I managed to fix the issue.