Me too!
I have an SQL database with lots of employee info. Also employee jpg headshots. The headshots are separate jpg files. The file names are just a field in the employee database. I need a tool that will convert that database into a visual set of headshots in a traditional orgchart layout. It would run on my intranet. It should paint org charts on the fly. Start with a view of the CEO and his direct reports. Names and titles are immediately above their pics. Click on a subordinate's headshot pic, and see a new page with him/her at the top, and a new set of subordinates. And so on. The whole thing could work if I would only have to add a field to my database for each employee called "reports to" with the name of that employee's manager. The whole thing would be smart enough to figure out the current org structure just from that field. Can't have some separate interface to maintain it, just want it to display based on my SQL database. You guys know where to get this, call me asap. --Jeff VEtterick, VP Mktg, AFS 405-782-1490