Displaying text boxes for labels

[gmazza via AccessMonster.com]

Hey there,
I have a form that I created and for the label, I created a text box and am
actually getting a value from table 1.
For the value of the label, I created a text box and get the value from table
2.

These tables will always have equal records and they are linked to eachother.

So I want to display all the labels from table 1 on 1 page of the form, no
scrolling, and on the same page, right beside the label, I want to display
the value from table 2.

I have 2 issues:

1. I can't seem to display ALL the fields(labels) from table 1 on 1 page in
the form, without scrolling through records.

2. I want to make the fields next to the label, those coming from table 2,
into a combo box.
Then when I choose from the combo box for each field(label), it all gets
saved into a table for reporting purposes.

I tried making the form a continuous form, and that displays all the records
on 1 page, but when I choose a value from the combo box, it changes that
value for each record on the page. I want that value from the combo box to
save for THAT field(label). So I want to be able to have different values
from the combo box saved for each record.

I'm not too sure what I need to do exactly. If you need more info, I can
provide a more detailed description of the problem.
Thanks for your help in advance!

 

[Beetle]

If you need more info, I can provide a more detailed

description of the problem.

Please do. I've read your post twice and really have no idea
what it is you are trying to accomplish. On the surface it makes
no sense.

You appear to be saying that you have two tables with identical
structure and data, and you are trying to combine data from these
two tables (which is already redundant to begin with) and store it
in a third table??!

Maybe I'm missing something.

 

[gmazza via AccessMonster.com]

Thanks for your reply Beetle. Here is a better description:

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.

If you need more info, I can provide a more detailed
description of the problem.

Please do. I've read your post twice and really have no idea
what it is you are trying to accomplish. On the surface it makes
no sense.

You appear to be saying that you have two tables with identical
structure and data, and you are trying to combine data from these
two tables (which is already redundant to begin with) and store it
in a third table??!

Maybe I'm missing something.

Hey there,
I have a form that I created and for the label, I created a text box and am

[quoted text clipped - 27 lines]

provide a more detailed description of the problem.
Thanks for your help in advance!

 

[Beetle]

Well, your table structure looks a bit off, but it's hard to say
for sure because I don't think you posted all of your tables.
I'm assuming you have a ClinicalTrial table with ClinicalTrialID as
the PK, but I don't know why you have that field as a foreign key
in all three of the tables you posted. I'm also guessing that your
PatientData table is intended to be a junction table to manage
a many-to-many relationship between the ClinicalTrials table
and a Patients table?

How does the Criteria relate? In other words, which of the following
statements is true;

1) Each record in ClinicalTrials should have one Criteria with one or
more related CriteriaOptions.

2) Each *patient* in a Clinical Trial should have one Criteria with one
or more related CriteriaOptions.

3) None of the above

--
_________

Sean Bailey

Thanks for your reply Beetle. Here is a better description:

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.

If you need more info, I can provide a more detailed
description of the problem.

Please do. I've read your post twice and really have no idea
what it is you are trying to accomplish. On the surface it makes
no sense.

You appear to be saying that you have two tables with identical
structure and data, and you are trying to combine data from these
two tables (which is already redundant to begin with) and store it
in a third table??!

Maybe I'm missing something.

Hey there,
I have a form that I created and for the label, I created a text box and am

[quoted text clipped - 27 lines]

provide a more detailed description of the problem.
Thanks for your help in advance!