Actually you can have a field in the employees dataset that lists the
manager overseeing
and when you query your employee you can pull that field
and you can also use a wild card to find all employees under that
manager.
Best,
Karl
On Mar 23, 2010, at 9:17 AM, kennethkawam...@gmail.com wrote:
I am not a database person but I think in this case you would have 2
tables in the database: one for roles/report lines and one for
employees - they are two completely different data sets. (And the 3rd
table for the relationships between the two.)
--
Kenneth Kawamoto
http://www.materiaprima.co.uk/
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Karl DeSaulniers
Design Drumm
http://designdrumm.com
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders