I am designing a rather hefty database, so to limit the length of 1
particular form I created a table (i.e. "List - Exam") with multiple
values
that I am using another table (i.e "Exam") to reference as a combo box (a
limited drop-down list to prevent the data enterer from inputting
additional
data that is not in the list). There are multiple field headings in "Exam"
Table with the same setup but of course different Table/Query limitations
that relate to each field heading.
Ok, so my question is, can I (in the form -"Exam Form"- that references
"Exam" Table) edit a text box (that will be placed next to a drop-down
list)
that will reference the values that can be selected in the drop-down list?
And (more im****tantly) can I based on the value selected in the
list/combo
box ex****t a specific numerical value for the text that is in the list
box?
The idea is that I want the data enterer to slect something like medical
related data that can be quatified with a number and in the end sum up the
values like a scoring system.
Example: Injury Type (List/Combo Box) = Head Injury, Stomach Injury, Toe
Injury, Not Applicable
For "Head Injury", ex****t numerical value 3
For "Stomach Injury", ex****t the numerical value 2
For "Stomach Injury", ex****t the numerical value 1
For "Not Applicable", ex****t the numerical value 0
Summing values in forms is an easy expression builder, so that shouldn't
be
a problem. I hope this isn't too complicated a problem. I hope someone can
help!
|
