I looked up the UserIDs for both her old and new name in the Users table.
If I take her old UserID and use that value to filter the ReferenceID of the TaskAssignments table as well as filter the IsCompleted field of the Tasks table for tasks not complete, I see that the numbers match up with what she sees on the console for open tasks. ((Joining Tasks and TaskAssignments allows me to narrow down only open tasks under her old name. Without the join I get everysingle task assignment regardless of it being opened or closed. I am only interested in fixing her open tasks.))
I am thinking if I update the ReferenceID field from her old UserID to her new UserID in the TasksAssignments table, that should allow the task to display for her new name.
My only concern now, however, is that even though she can see those old tasks under her new name .... permissions may still be a problem.
- Do you think permissions would an issue?
- Do you think there are any other tables I may need to update?
I may just manually update a few of her tasks and have her test it out.