Any thoughts?

Here is what I want to do. I'm making a database of classes. Some classes, are offered more than once, and will have additional times available. I'm wondering if when a record is pulled up - if I can have the different times listed, or in a pull down menu. How would I do this? Currenly I only have one table - each class (not time) is one record.

I also need them to be able to be listed seperate enough somehow that a user can click on the time they'd like - which would submit it to a form so we know what class and what time they're interested in.

Any thoughts on this would be appreciated.

Thread moved from 'Database Help' to 'Programming Theory' by CodeKadiya.

Reason: theory stuff

DO you have a database already designed? And if so, what does it look like?

Are you asking how to implement this into your current design, or how to work witht he one you have?

It is set up in one table:

id
class
date
time
location
description
fee

I'm not sure I can create another table - so using this same one would be best - but possibly with another. I'd really like to use what I already have though.