G
gmazza via AccessMonster.com
Hey there,
I have a complicated problem that I will try to explain properly.
I have 3 forms.
1st form I add CriteriaValues to, so each record in the table has a
CriteriaValue.
TableName:Criteria - CriteriaId, ClinicalTrialId, CriteriaValue
2nd form I have a combo box of all CriteriaValues from the 1st form, and
based on the CriteriaValue I pick, I can add any number of
CriteriaOptionValue's for the repsective CriteriaValue, and those
CriteriaOptionValue's get stored in a table.
TableName:CriteriaOption - CriteriaOptionId, ClinicalTrialId, CriteriaId,
CriteriaOptionValue
For the 3rd form I need to display all the CriteriaValue's on the form that I
have in the table.
Right beside each CriteriaValue, I need a combo box with the
CriteriaOptionValue's I added in the 2nd form.
Once I choose the CriteriaOptionValue's for each CriteriaValue, I need that
information saved in another table.
TableNameatientData - PatientId, ClinicalTrialId, CriteriaId,
CriteriaOptionId
The 1st and 2nd form work fine, I am having problems getting the 3rd form
working.
I can't seem to display all the CriteriaValue's or the CriteriaOptions for
the respective CriteriaValue.
I assume I need a subform to display all this info, but I don't know what
Child and Master fields I need to be linking or anything.
I also could be needing more or different fields in my PatientData table, not
sure.
Any help is appreciated, thanks!
I have a complicated problem that I will try to explain properly.
I have 3 forms.
1st form I add CriteriaValues to, so each record in the table has a
CriteriaValue.
TableName:Criteria - CriteriaId, ClinicalTrialId, CriteriaValue
2nd form I have a combo box of all CriteriaValues from the 1st form, and
based on the CriteriaValue I pick, I can add any number of
CriteriaOptionValue's for the repsective CriteriaValue, and those
CriteriaOptionValue's get stored in a table.
TableName:CriteriaOption - CriteriaOptionId, ClinicalTrialId, CriteriaId,
CriteriaOptionValue
For the 3rd form I need to display all the CriteriaValue's on the form that I
have in the table.
Right beside each CriteriaValue, I need a combo box with the
CriteriaOptionValue's I added in the 2nd form.
Once I choose the CriteriaOptionValue's for each CriteriaValue, I need that
information saved in another table.
TableNameatientData - PatientId, ClinicalTrialId, CriteriaId,
CriteriaOptionId
The 1st and 2nd form work fine, I am having problems getting the 3rd form
working.
I can't seem to display all the CriteriaValue's or the CriteriaOptions for
the respective CriteriaValue.
I assume I need a subform to display all this info, but I don't know what
Child and Master fields I need to be linking or anything.
I also could be needing more or different fields in my PatientData table, not
sure.
Any help is appreciated, thanks!