I am working in an education template and want to see if there is a way to
create a field that can be added to periodically to show all the courses a
person takes from my instructors. I created a field named course but it is
only allowing me to put one course in. How can I make the field list all the
courses?
Thanks,
Nantika
You're misunderstaning how relational databases work.
A field should be "atomic" - having one and only one value.
A student-enrollment database is a perfect example of a (very common)
many-to-many relationship. Each Student can take zero, one, or many Courses;
each Course is taken by zero, one or many Students. The proper structure for
this has three tables:
Students
StudentID <primary key>
LastName
FirstName
<other biographical data, but nothing about courses>
Courses
CourseNo <primary key>
CourseTitle
<other info about the course as a thing in itself>
Enrollment
StudentID <link to Students, who's enrolled>
CourseNo <link to Courses, what are they enrolled in>
<other info about this course as it pertains to this student, e.g. date
enrolled>
You would enter multiple *records* into the Enrollment table for each student.
You may want to look at some of the tutorials in these webpages. I believe
that some of the tutorials use class enrollment as an example:
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/
A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html
A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials