One class, multiple students?

You.... want to talk?

"HELENA SMITH" 254 FLINT ST wrote in message
...
my is helena smith dale jr why are not talk
"Eric IsWhoIAm" wrote in message
...
I have four tables created so far: Courses, Instructors, Courses and
Instructors (which shows the Course and Instructor Name fields, but holds
their IDs since those are the keys), and Students. Now, I wish to create
a
Classrooms (or something similar) table which will allow me to pick the
Course from Courses and Instructors, and hold multiple Students for each
Course. I am unsure how to do this in Access.

Each student can have multiple classes; each class has multiple students.
I
only want to store the information once, though. I can't declare an array
of
Students for each class.... can I? What is the right way to do this?

Thanks,
Eric

"HELENA SMITH" 254 FLINT ST wrote

my is helena smith dale jr why are not talk

Helena,

This isn't a chat room nor e-mail; it is a newsgroup devoted to Questions,
Answers, and Discussion of Microsoft Access database software. I can only
guess that you accidentally posted here, and intended to post where "dale
jr" would see your post. Probably the reason "why dale jr are not talk" is
that he doesn't participate in the newsgroup comp.databases.ms-access. It
may also be a reason why you will not see this response, because you may not
accidentally get into the newsgroup again.

Larry Linson
Microsoft Access MVP