If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fields
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! |
#2
|
|||
|
|||
Fields
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] |
Thread Tools | |
Display Modes | |
|
|