sub-departments might bet their own table. depends. are sub-departments also departments in and of themselves (e.g. would a sub-department be directly under a division? or only under another department)? if it's the latter, then i would suggest a sub-department table. If it's the former, then you may be looking at some recursive SQL.
On 7/21/06, Steven Sprouse <[EMAIL PROTECTED]> wrote: > 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:247295 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
