List box field value determining the value for another field

[DarthZ]

Hi,

I have a form where the first field determines the value of the second field. The first field is a multi select list box and so I was wondering if it is possible to have it so that if a certain item is selected in this list, it will fill in the second box with a number value of 1-5. Here is an example if that was not too clear:

List box
red
purple
green


blue
violet
black
white

purple = 1 blue = 2 violet = 3 ...etc

How exactly could I do this, and if the list box is not ideal then would a combo box be better served in this situation?
And just a note: the list box currently contains about 12 catagories, but not all of them will equate to a value for the second value, meaning that the second field is only dependent on some of the values from the list field.

I hope this made sense, and Any advice is appreciated,

Thanks

[orange]

Research Cascading combo box for the concept involved
http://www.baldyweb.com/CascadingCombo.htm

Why did you choose Listbox?

[DarthZ]

Thanks for your response.

I chose the listbox because we need often times need to make multiple selections for this field.

I'm not too sure if a cascading combo box is what I was looking for because you still have to select an option for the second field. Using my initial example, I want it so that when somebody selects purple for one field, it automatically enters 1 for the second field. Is this something that can perhaps be done in a query instead? Kind of like calculating age from birthdates in a query?

[orange]

I think there is some miscommunication.
The typical cascading combo goes something like this

You have need for a US State and the system has been set up with
a combo for
Regions:
North
East
South
West

And Each Region has the States contained in that region.

So when you select East in Combo 1, only Eastern states are available in Combo2.

This doesn't seem to be what you need, but you did start by saying

the first field determines the value of the second field

which is the way a question about combos often appears.

I think you should tell us more about your application. There may be some alternatives.