Form/subform based on inner join tbl

[L. Petchell]

Hi,

I'm working on a database for a homeschool co-op in Oregon. Our school has
grades k-12 and we have the basic and elective type classes. So, the database
is set up with student info and class info. This would seem to be a "many to
many" relationship.

I've set up a student main form and our goal is for the school directors to
assign classes to students from the classes subform (which should pull from
the classes table). From what I've researched in many to many relationships,
you need an inner join table. So I created a table that has these fields;

StudentClassesID
StudentID
ClassesId

I would like the directors to go to the main student form, pick a student,
then assign classes to that student by selecting the classes from a drop down
list. The classes willl then be related to the student. I'm just not sure how
to set up the subform to handle this. I would like the classes subform to be
in datasheet view.

Another kink is that the main classes table uses look up fields based on
several smaller tables (such as; tblClassNames, tblClassLevel, tblType). This
was done to keep uniform spelling throughout. I don't think the main classes
table will mess up the inner join on the classes subform............but I
can't seem to get the set up correct.

I'm using Access 2003 with Win XP. Please also know that I'm only an
intermediate level user and do not know SQL. Other than a few classes I've
taken, I'm self-taught (enough to get myself into trouble offering my
services).

Any help is greatly appreciated.

 

[strive4peace]

Hi L,

I will do what I can to help you -- I homeschool one of my children and
am a strong believer in homeschooling! Cheers to you! I am interested
in learning about homeschooling laws in other states, so if you could
point me to some guidelines for yours, I will look

The first thing you need to do to track your information is set up your
data structures efficiently and become familiar with the basics in
Access you will need to use.

send me an email and request my 30-page Word document on Access Basics
(for Programming) -- it doesn't cover VBA, but prepares you for it
because it covers essentials in Access.

Be sure to put at least "Access Basics" in the subject line so that I
see your message...


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*