My mind just isn't working, I need help with some logic here if any of you would.... I have a table that houses all employees and each is unique by employee number, there is a hierarchy of management by storing each employee's supervisors employee number in the record. For example my bosses emp num is 24, I am emp num 44. My record looks like this. empnum fname lname supvnum 44 ray Bujarski 24
I need to create a structure that has a hierarchy list of employees, I have people reporting to me so, my supervisor should have all my employees listed in his list of employees along with myself. Can anyone help me with this logic....I am at nerves end. Thank you! Ray ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
