Fields

  • Thread starter Thread starter Nantika
  • Start date Start date
N

Nantika

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
 
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
Click to expand...

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
 
Back
Top