Multivalued Field

[Junaid]

Hi
I have a multivalve field in a table of students database. This contains
subjects to be selected by the students. Each student can select five , six
subjects. One has to check the box opposite to each subject. There are
however certain groups which have to select some particular subjects. For
example The Pre-Medical Group can select only " 6 particular subjects". I
have placed one option among the list of subjects as "Pre-Medical" group. I
want if the Check box of "Pre-Medical" group is checked then all the
relevant subjects of Pre-Medical group should automatically be checked.
Please help me in this regard.

 

[TedMi]

Do NOT use multivalued fields. MS made a grevious design error in Acc'07 by
implementing these. Instead, Google "one to many relationships" to learn how
to do it properly.
-TedMi

 

[John W. Vinson]

Hi
I have a multivalve field in a table of students database. This contains
subjects to be selected by the students. Each student can select five , six
subjects. One has to check the box opposite to each subject. There are
however certain groups which have to select some particular subjects. For
example The Pre-Medical Group can select only " 6 particular subjects". I
have placed one option among the list of subjects as "Pre-Medical" group. I
want if the Check box of "Pre-Medical" group is checked then all the
relevant subjects of Pre-Medical group should automatically be checked.
Please help me in this regard.

This is very straightforward in a properly designed database (with three
tables, Students, Subjects, and Enrollment joining them).

It's probably impossible using Microsoft's misdesigned multivalue field
feature.