I have a linked table with about five columns of assorted data. Class, Value Name, and Value are the columns I'm interested in. I want to pull three values from Value Name and display the values in the Value column. I can get my list of displayNames correctly, however, the second and third column in my query are just repeat data.

displayName, Extension, Default Workstation all reside in the Value Name column with the values I want to retrieve in the Value column.

Just one linked table I'm drawing from. Thanks for any tips.

Oakguy

evils of teable-level lookups (http://www.mvps.org/access/lookupfields.htm)

how to do it properly (http://www.access-programmers.co.uk/forums/showthread.php?t=163373&page=2) (start at post #18, then read to the last post)