There is no magic wand to do that. In hindsight, it is better to design apps where there are tables to hold which users are assigned to work positions. That way it is easier to make the change on some supporting tables and have it flow into many places in the app as a post to heart coding these choices all over the place.
What approaches to leave the user ID and email alive for the old user and monitor the incoming emails to then trace back and fix them.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------