View Single Post
  #4 (permalink)  
Old 11-25-09, 07:30 AM
wirehopper's Avatar
wirehopper wirehopper is offline
-
 
Join Date: Feb 2006
Posts: 2,516
Thanks: 20
Thanked 109 Times in 106 Posts
I would start by looking at the AD data management to clean it up. You need reliable data for it to work.

The next step I would take is to get a whiteboard and try to layout a relational database to support it. Perhaps tables for schools, campuses, and groups. Each of these tables would have a unique id for each record, as well as a parent id. This would allow a hierarchy of one to many relationships.

Another approach would be to just use the AD data. Have a script that builds the menus every night, extracting the data from AD. That way, you don't have to maintain the data in multiple places.
Reply With Quote
The Following User Says Thank You to wirehopper For This Useful Post:
Ryan75 (11-26-09)