Okay, so I understand the Division and Departments ID thing. Now, what if there is a sub-department of a department? For example: We have a division of Instruction...under that division we have a department of Curriculum & Instruction. Under the C&I department we have sub-departments like Health, Social Studies, Math, etc.
I know those sub-departments need to go in the departments table, but how do I link them together with the department? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247291 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4