M
mjameson
I am a beginner to access and I have been given the task to create a
form that will eventually be published to the company intranet site to
be updated by staff members.
I am having a hard time with one of the requirements.
On the form there should be a drop drown menu titled "Resources"
which has about 15 different subject areas staff can select from.
(these are presentations the staff give at public events) Then based
on the subject in the combo box, a subform should come up with a list
of handouts. They should be able to check off which handouts were
given out and also have an area to fill in how many were distributed.
I am having a hard time linking these together.
What I have done is create a separate table, "tblresources" with
the primary key as the resource and each subject as the data. Then I
created separate tables for each subjects handouts, with every handout
as a yes/no field, and a field to type in the number of handouts
distributed. Staff members need to be able to check off all that apply
for the handouts.
I created subforms for the subjects' handouts, and the subform seems
to be working ok. The problem is I have no idea how to link each
subform to the selected subject from the combo box. None of the
subforms or the handout tables have primary keys and right now do not
have a relationship to any other table.
Do you have any suggestions as to how I might go about correcting this?
I know one main problem is that none of the handout tables have a
primary key.
Thanks for any help!
form that will eventually be published to the company intranet site to
be updated by staff members.
I am having a hard time with one of the requirements.
On the form there should be a drop drown menu titled "Resources"
which has about 15 different subject areas staff can select from.
(these are presentations the staff give at public events) Then based
on the subject in the combo box, a subform should come up with a list
of handouts. They should be able to check off which handouts were
given out and also have an area to fill in how many were distributed.
I am having a hard time linking these together.
What I have done is create a separate table, "tblresources" with
the primary key as the resource and each subject as the data. Then I
created separate tables for each subjects handouts, with every handout
as a yes/no field, and a field to type in the number of handouts
distributed. Staff members need to be able to check off all that apply
for the handouts.
I created subforms for the subjects' handouts, and the subform seems
to be working ok. The problem is I have no idea how to link each
subform to the selected subject from the combo box. None of the
subforms or the handout tables have primary keys and right now do not
have a relationship to any other table.
Do you have any suggestions as to how I might go about correcting this?
I know one main problem is that none of the handout tables have a
primary key.
Thanks for any help!