lookup problem

  • Thread starter Thread starter dspent
  • Start date Start date
D

dspent

I have a table that is linked to another for the purpose of providing lookup
data...

EXAMPLE:

tbl 1 has fields like
callid
date
time
problem
type
et.....

It is the type field that is set to lookup it's data from tbl 2 In table 2
there are 2 fields the typeid and type

The lookup works fine. When I am entering data into tbl 1 as soon as the
focus is on the type field I get a drop down menu that displays the list of
types....the problem is that when I select the type I want what shows up in
the field is the type ID and not the actual type...

So in that colum instead of CONFIGURATION I will get 2003 which the ID
number for that call type.

How can I get access to show the desired instead of the ID?

How this makes sense if not please email me at (e-mail address removed)

Thanks,,,
 
Check and make sure the width of the first Column (assuming this is the
bound Column "TypeID") is zero. In this case, the 1st visible column is the
second Column which should be your "Type" Column.
 
The problem is not what's visible in the list....The problem is that once I
select the TYPE what'd displayed in the field, and ultimately on reports and
in forms etc...is the TYPEID...

I want it to show the value in TYPE not the ID...
 
The problem is not what's visible in the list....The problem is that once I
select the TYPE what'd displayed in the field, and ultimately on reports and
in forms etc...is the TYPEID...

I want it to show the value in TYPE not the ID...
Click to expand...

You're another victim of Microsoft's misdesigned, misleading, and all
but useless Lookup feature. The table actually CONTAINS the TypeID.
That very simple fact is simply concealed from your view by the Lookup
feature - it *LOOKS* like the table contains the Type, *but it
doesn't*.

Base your Report on a Query joining your table to the Types table, and
pick the Type from the Types table; on a Form, use a Combo Box bound
to the TypeID field but using the Type as the first (or only) nonzero
width field. It is *not* necessary to use a Lookup field in the table
design to do this - you can use a combo box (a "lookup" if you want to
call it that) on your Form anyway.
 
I went and looked at the Northwind Traders Sample DB and found out how they
did it....
First, don't use the lookup wizard because it will set the field type to
NUMBER....when it should be text.
and last, manually setup the SELECT statement to pull ONLY the field you
want displayed and it works perfectly.
 
Back
Top