By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,118 Members | 1,134 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,118 IT Pros & Developers. It's quick & easy.

Lookup Tables using same number for different descriptors

P: 4
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!!!
Oct 25 '06 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,473
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?
Oct 25 '06 #2

P: 4
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?
Oct 25 '06 #3

NeoPa
Expert Mod 15k+
P: 31,473
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.
Oct 25 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Oct 26 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.