B
bavjean
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!
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!