option buttons on a subform

[Guest]

Hi

Hopefully someone could help. I have a database including a large table
holding student details, id, name, etc. A second table houses a list of
subjects with subject codes, 1 = English, 2 = French, 3 = Art, etc. A third
table connects these two with id and course_id. What i am trying to do is
create a subform based upon this third table where, for any selected student,
all the subject entries in the subject table are displayed in the form with
an option button next to each entry. This will enable the user to check one
or more entries for subjects taken by any particular student.

The subject entries onto the form need to be automatically displayed as the
number or subjects is constantly changing and so static links to record
fields isn't really an option.

I can get it done through a datasheet view but this isn't user friendly and
so i would require all the subjects to be displayed, with an option box next
to each.

Clear as mud?? Any ideas??

Many thanks

Rich

 

[Steve Schapel]

Rich,

I know this is not what you asked for, but... you could have a
continuous view subform, with a combobox to list the subjects available,
and for the student concerned, select the subjects taken from the
combobox. That way, the form will show all the subjects taken for that
student. Do you really also want to show the subjects not taken? If
so, you will need to create a record in the "third" table for each
available subject for the student, and then have these shown in the
subform. This is easy to do... you just need to make an append query
based on the Subjects table and add the records to the "third" table,
along with the ID of the student. I guess you will then also want a
Yes/No data type field in the "third" table where you can indicate which
subjects the student takes and which ones he doesn't.

 

[Guest]

Thanks Steve. I'll try it

rich

Rich,

I know this is not what you asked for, but... you could have a
continuous view subform, with a combobox to list the subjects available,
and for the student concerned, select the subjects taken from the
combobox. That way, the form will show all the subjects taken for that
student. Do you really also want to show the subjects not taken? If
so, you will need to create a record in the "third" table for each
available subject for the student, and then have these shown in the
subform. This is easy to do... you just need to make an append query
based on the Subjects table and add the records to the "third" table,
along with the ID of the student. I guess you will then also want a
Yes/No data type field in the "third" table where you can indicate which
subjects the student takes and which ones he doesn't.