Im working on a site that has users, and classes. Each user can be enrolled in one or more classes. Each class has a class code that is added to the users "classcode" field when they enroll in the class. Ive been looking for a way to add multiple values to one field and found that most people advise against it for semantic reasons.
Im wondering what the better practice would be for this situation. How would I relate a specific user to more than one class without doing it this way?
The only other option I thought of would be to dynamically add a field to the users table when a class is created but this will raise problems and be a strange workaround in my mind.
If anybody has any input on this, Id love to hear it, thanks!