Being a newbie, I have written my (large) trainng database with students and courses but again I am getting confused.
I have students who are doing courses - one student can do many courses AND each course can have many students on it.
I tried to follow all the many-many tutorials and tips but got myself in a right state! So I opened the student template and used that, importing my data as such ..... At the moment then I have a table listing all students (good) and a table with courses (not so good) which duplicates data, ie a single student is on a few lines if he has done more than 1 course. Get me?
Now ..... This works at the moment but I want to tidy it up and have a report which I can generate from a combo box which lets me specify department of study.
PS: I'm a newb so speak English!