Bot to assign the records of a deleted user to another existing user

HELP
Practical example:
- I have a user registered on my system using the function: Usersettings();
- Everything that this user registers in the system leaves his user code recorded, so that we can identify who made the necessary registration;
- However, when I am excluding these Users because they are no longer part of the company, it turns out that in the other tables, that record is orphaned by a registrar. Only the code of that deleted user will be displayed, instead of their identification;
- My main objective would be to create a way in which, when deleting this user, the system would ask me if I would like to assign all of this user's records to any other user. This way, an (INPUT) box would open allowing another user to be selected, so that all the codes of the deleted user would be replaced by the code of another selected user.

Thank you very much for your precious time dedicated to this urgent matter of mine!

0 6 272
6 REPLIES 6
Top Labels in this Space