multiple column lookup

  • Thread starter Thread starter Cleo
  • Start date Start date
C

Cleo

My multiple lookup column displays
97203 15 12

when I want it to display
97203 C025 Portland

The data for the lookup column is stored in another table in these columns
primary key (autonumber) value 1 value 2

Thanks! I have tried everything I can think up----twice.
 
I'm not sure what you are talking about when you say multiple column lookup.

My guess is that it is a control (a listbox or combobox). If so you will need
to modify the row source of the control.

You will need to have both tables in the query and you will create a join
between the two tables by dragging from the column that displays 15 to a
column in the second table that also displays the 15.

You will show one column from the first table for the first and two columns
from the second.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Relationships and Lookups 6
lookup and return column number 2
lookup table based on two criteria 3
newbie question: lookup always returns ID, not combo box value 4
How to Return the value of field from two lookup? 1
Vlookup Function 1
multivalued lookup columns 3
Lookup one value, Return matching correspnding values 7

Back
Top