Lookup Question

[Brad]

I'm relatively new to access, so bear with me as I try to explain my issue. I
have 2 tables of interest. One table, I'm using as a lookup table and I have
data stored in it like.
Col 1 Col 2 Col 3
X 1 A
X 2 A
W 1 B
W 2 A

In my main table I have a field that I'm trying to use the lookup wizard to
make a combo box that displays only the Distinct values from Column 1 in my
look up table. So the only option you would see would be X and W....not X X W
W. I may be going about this all wrong so any information you can provide
will be useful.

Thanks,

 

[John W. Vinson]

I'm relatively new to access, so bear with me as I try to explain my issue. I
have 2 tables of interest. One table, I'm using as a lookup table and I have
data stored in it like.
Col 1 Col 2 Col 3
X 1 A
X 2 A
W 1 B
W 2 A

In my main table I have a field that I'm trying to use the lookup wizard to
make a combo box that displays only the Distinct values from Column 1 in my
look up table. So the only option you would see would be X and W....not X X W
W. I may be going about this all wrong so any information you can provide
will be useful.

Thanks,

One thing you're doing wrong is using tables for data interaction; another
problem is using the Lookup Wizard at all (a decision made more likely by the
first error!)

Most of us really dislike the Lookup Wizard. For a critique see
http://www.mvps.org/access/lookupfields.htm

If you use a Form (instead of a table), you can easily put a combo box on the
form based on a Distinct query:

SELECT DISTINCT [Col 1] FROM [tablename] ORDER BY [Col 1];

to get your X, W. It's not clear how the other columns come into the game.