Lookup Problem

P

Peter

ok...
I have a table with 2 feilds in it...
The first feild is a 4 digit number...
The Second feild is a city...
I made a look up with the look up wizard...
They way I want it to work is that i type in the 4 digit
number from the first feild and it comes up in the look
up, Then I next to that number a city apears (in the
second colum of hte look up). I don't want the 4 digit
number to show up but i want the City to show up in the
field instead.

Any Suggestions??
Thanks,
Peter
 
Top