On Sat, 17 Apr 2010 09:18:01 -0700, Nantika
wrote:

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/acc...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

--

John W. Vinson [MVP]