Need help with table structure for current project.

[jimcant]

Basically, I am designing a student planner for a specific major in my university. We are coding in Excel/VBA and using Access as our database. As of now we have two tables "Users" and "Classes". Once a user logs in, we want to show them the specific classes that they have completed along with the classes that they have yet to take. I can't decide the best way to go about doing this without being redundant... Do I need to create a new table for each user, "Last_Name_Classes_Completed" for example, or is there a better way to "add up" all the classes that someone has taken based on the unique "class_id" found in the "Classes" table?

I hope that I was clear in what I am attempting to accomplish, but if you need any more information, let me know.

 

[WIS]

a better way to "add up" all the classes that someone has taken based on the unique "class_id" found in the "Classes" table?

Yes, that's the way to do it. You will also need "UsersID" in the "Classes" tbl as well.