Multivalued Field

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.

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

"Junaid" wrote in message
...
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.

On Tue, 7 Jul 2009 22:54:22 +0500, "Junaid" wrote:

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.
--

John W. Vinson [MVP]