Display correct info in sub form

  • Thread starter gmazza via AccessMonster.com
  • Start date
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.
TableName:patientData - 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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top