Modifying output of lists in forms

[Axess08]

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 importantly) can I based on the value selected in the list/combo
box export 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", export numerical value 3
For "Stomach Injury", export the numerical value 2
For "Stomach Injury", export the numerical value 1
For "Not Applicable", export 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!

 

[Ryan]

You would want to put the number values for each injury type in the List
table. I would look like this.

Head Injury 3
Stomach Injury 2

Now, when you create your relationship between the List and exam tables, the
injury type number value will be associated with the injury. In a query with
both tables, you could add both fields, injury, and number value. Now when
you make your form, you could add your dropdown for the injury type, and have
a textbox that shows the number value as soon as you select the injury type
from your dropdown.

 

[Evan Keel]

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 importantly) can I based on the value selected in the list/combo
box export 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", export numerical value 3
For "Stomach Injury", export the numerical value 2
For "Stomach Injury", export the numerical value 1
For "Not Applicable", export 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!

Post your table structures. Your database should reflect your problem
domain, not user interface issues.