Ok I can't seem to get my head around this.
To simplify I will take the two tables in question
I have a database (access) which I use for the high school.
The two main tables involved are "students" and "courses"
What I am trying to achieve is this:
In the Students Table I have all the details on the Students
I want to be able to add a course and have it appear on the students details.
The catch is that I want to add more courses on the student page as the student enrolls in them and essentially have each course that the student is currently doing, listed in the students details page. I then want to be able to have a drop down list denoting the status of that particular course. ie Not Started, Enrolled, Completed
I would have absolutely no objections to paying someone to help me with this as I don't think its just a "hey do this" answer.
If someone reads this and thinks that i should look in a particular area for direction feel free to point me there. Any help would be grateful <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2605&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
