This is my first post on here, so hopefully I can find someone to help me! I'm not sure if this is the right folder to post this question or not, but here goes...

I'm trying to build a school site similar to www.wcboe.k12.md.us/content/sch_schools.cfm where it will generate a list of our schools by category and then link to a coldfusion generated page that will display general information about a specific school. I've currently got two databases. One called SchoolType that has 4 fields, Elementary, Middle, High and Centers. My records for these fields include the abbreviated names of our schools and centers. I have another database with SchoolID, SchoolName, SchoolNameLong, SchoolAddr, etc.

I'm just stuck on how I can get a SQL suery to generate a table or jumpmenu (similar to this example www.mcps.k12.md.us/schools/) with all of our schools, sorted by school type and then have it link to a page specific to a school.

Can anyone help me get started?