automatically repeat supervisor information
I have a table of staff, with staff personal info, position(representative, area direcotor, regional director, ), supervisor (a drop down list made from this very table). So a representative's supervisor is an area direcotor, and an area director's supervisor is a regional direcotor. But they are all in this same table.
Now in another layout notifying customers of services provided, I need to put the representative's name, his phone number, his supervisor's name, and his supervisor's phone number, etc. Since they are all in staff table, I would like it to work this way: put in representative ID and then all other information would appear automatically.
How could I do this?