I am creating a database for a website (lvjrfest.org). My problem is this:
Students will (once I'm finished) be registering for one of 30 Events. Each Event has between 5 and 20 Difficulty levels. The Difficulty levels are different for each Event, although some may overlap. For example, the Piano Concerto Event has three Difficulties: Easy, Medium, and Advanced. The Vocal Yodeling Event has 5 Difficulties: Easy, Medium, Caterwauling, Screaming, and Advanced.
The Events table is trivial; no problem there. How do I design the database so that Difficulties are associated with their Event? I thought of creating a table for each Event called <event>DifficultyLevels, but I wonder if there isn't a better way...
My ODBC and UDL connections are working fine. Tested successfully. But under Liked severs on SQLServer it does not work. It hangs up for ever untill i close the Enterprise session. Can't query either.