i'm a newb on this forum so i want to apologize if this has been discussed already. I'll try to explain my situation as best as i can.

What i'd like to do is have a student table and a class table. I would like to have mutiple classes for one student. As a query i would like to show all the classes taken by particular student. The classes table needs to be easily updated. I'm new sql, so i'm having trouble creating a good database. Any help would be appreciated.


Thanks
sam

Try to find good documentation or buy some good SQL related book.
Here are exmple urls:
http://www.w3schools.com/sql/default.asp
http://www.campus.ncl.ac.uk/databases/design/

If you dont't like these urls, try to search in google.
This forum is for solving the real troubles and problems not for teaching.