If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Modifying output of lists in forms
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! |
#2
|
|||
|
|||
Modifying output of lists in forms
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. -- Please remember to mark this post as answered if this solves your problem. "Axess08" wrote: 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! |
#3
|
|||
|
|||
Modifying output of lists in forms
"Axess08" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|