Query column info rather than actual value

[nicnicman]

In a table I have a field that gets its value from a lookup with multiple columns. Is it possible to query information in the columns rather than the actual value.



Here is an example of a single field value in the table I want to query (this would be in a drop down box in the table):

ID | Name
1 Nick
2 Nick

The actual values are the 1 and 2, but I would like to query the name 'Nick'. How would I do this?

Thanks for any suggestions.

[alansidman]

In your query, you need to join the lookup table with the main table. Include the Name field from the second table in your query grid. Include the FK from the main table and this is what you will filter on, but make sure that the display box for this field is unchecked.

BTW: All lookups should be performed in a form and not directly in a table. Look here:
http://access.mvps.org/access/lookupfields.htm

Alan

[nicnicman]

Thanks for the help, but I'm not sure what you mean by FK.

[nicnicman]

That was an eye-opening read about look-up tables. My instructor actually requested that I add the look-ups for easier data entry. However, from what I was just reading, data entry should be performed in forms.

[alansidman]

Foreign Key. It is ID in the main table that links to the Primary Key in the lookup table.

[nicnicman]

Okay, thanks. I got it working.