Hello everybody.
Can someone point out please what is wrong with my work?
What I have so far:
People take part in experiments, and a record is made in
tblExperimentInstances. There are a number of different experiments, as
listed in tblExperimentType. I have the following table structure:
tblPeople:
PeopleID ,primary key
Surnname
tblExperimentInstances:
ExperimentInstID ,primary key
PeopleID ,foreign key
ExperimentTypeName ,foreign key
Date
Comments
tblExperimentType:
ExperimentTypeName ,primary key
Comment
Field ExperimentTypeName is data type Lookup Wizard and looks at the
values stored in its corresponding field in tblExperimentType.
Then, I have a form with a person details in textboxes. On this form is
a subform, with the experiment the person took part in listed in a
combo box. There is a navigation button on the subform to move to the
next record i.e. other experiments the person took part in. The subform
is based on the following query:
SELECT tblPeople. PeopleID, tblExperimentInstances.ExperimentTypeName,
tblExperimentInstances.Date, tblExperimentInstances.Comments
FROM tblPeople INNER JOIN (tblExperimentType INNER JOIN
tblExperimentInstances ON tblExperimentType.ExperimentTypeName =
tblExperimentInstances.ExperimentTypeName) ON tblPeople.PeopleID =
tblExperimentInstances.PeopleID;
In my subform, I have a combo box for the ExperimentTypeName (from
query, and the query gets it from tblExperimentInstances), and
textboxes for the Date and Comments.
What I want:
When I am in the subform for a particular person and I click on the
ComboBox for ExperimentTypeName, it should display a dropdown list of
the available experiments. At present I only get a blank list. I want
it to work as when I click on the column for ExperimentTypeName in my
table or query, where one can select which of the available experiments
this person takes part in.
Wow that was quite an explanation. I think it is simpler than I have
tried to put it - but it seems strange to me why it doesn't work.
Thanks in advance!