Hi all, sorry but I can't find the answer in the existing threads - probably because I dont know the correct terms for it.
But basically I have a main file from which all my company's staff are listed. In this file the 2nd and 3rd column is name and role/position respectively. I use the resource usage view so the hrs are noted in the right panel.

My company deals with multiple projects every week which have multiple roles/positions in them. Each project gets its own mpp file (having them all in one is messy apparently), and these individual project files share and extract the resource lists from the main file. The only column that is shared however is the name.

When I start a new project file I share the resources and assign them to a task, but - in an ideal world - after I assign the staff Id like to be able to see what role each person is for and ideally if there are any over-allocations (preassigned tasks to the resource) without having to revert back over to the main resource file to check it. In the main resource file the over-allocation of staff is highlighted red (in the resource usage)

And just to give some context, I took over this resource schedule system from my predecessor but they left without giving any proper training and I've never used MSP before. Of course no-one else knows how to do it either
FYI its MSP 2007

Any help is greatly appreciated and would know hours off my work load flipping back and forth between files and trying to remember names for roles!

Thanks!
Gary