I'm making a local Access\ColdFusion MX site in Dreamweaver MX that has all of my MP3s. I want to have it so it shows the bands on one page and if I click on the link it will take me to a page with all the Bands Songs. Sounds easy right? well, not if you are an idiot.

I have 2 tables in my database (bands, songs) and in bands i have the fields (bandID, and bandName) and in songs i have the fields (songName, songNumber, songURL, cdName, and bandID)

Thanks for any help you guys could give me.

Edited by - jetsdesign on 16 Jul 2002 03:37:10