Lookup Tables using same number for different descriptors

[mando1404]

I have a table that I use for dropdown menus in my Access database. The table was NOT constructed in the LookUp Wizard. My problem is that I want three descriptors in the dropdown to display the same number in the table because they mean the same thing in another calculation I am doing.

Is this possible?

Here's an example:

Not Available = 10
Complete = 10
Not Applicable = 10

When I assign my descriptors these codes, the drop down does not work correctly - no matter which one I choose, the dropdown always displays Not Available.

Thanks!!!

[NeoPa]

What's the DropDown you're referring to?
Is it within the field definition of the table?
Or maybe in a form designed to use the table?

[mando1404]

The information for the DropDown is in a seperate table - it's not stored in the field definition or the the form.


What's the DropDown you're referring to?
Is it within the field definition of the table?
Or maybe in a form designed to use the table?

[NeoPa]

I get that the data is in a table - but where is the DropDown itself?
Not on a form, or even in a field definition, so where?
I'm confused.

[MMcCarthy]

Your drop down is based on two fields [some value] and [some string].

You need this value for other purposes so create a new unique id field in the table as well

lookupTable
==========
ID (PK and AutoNumber)
someValue
someString

In your combo box change the following properties

Under Format tab

Column Count 3
Column Widths 0 cm; 0 cm; 3 cm

Under Data tab

Bound Column 2 (This will be the second column representing the 10)

This should now work properly. I am assuming the value of 10 is the one you want to use.