I am making a prototype for a database in Access. I have a student table, and a lesson table. one student can have many lessons. I want a field that says which lesson that was for the student, e.g. 'lesson 3'. I am very open to advice on making new tables, queries, fields, etc, my database is a prototype, so if you think it would be better to completely change it, then I am open to suggestions.
