Fields
in [Tables]
|
From: Nantika on 17 Apr 2010 12:18 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 -- Enjoy every day!
From: John W. Vinson on 17 Apr 2010 12:50 On Sat, 17 Apr 2010 09:18:01 -0700, Nantika <Nantika(a)discussions.microsoft.com> 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/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 -- John W. Vinson [MVP]
|
Pages: 1 Prev: One or two tables Next: create and print payroll check w/office |