AnsweredAssumed Answered

automatically repeat supervisor information

Question asked by hgscn on Jul 19, 2011
Latest reply on Jul 22, 2011 by hgscn


automatically repeat supervisor information


Hello gurus,

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?

Thank you!