Lookup Yielding Key Field Values Instead of Desired Field Values

Lookup Yielding Key Field Values Instead of Desired Field Values

Post by bmV3d » Sun, 22 Feb 2009 07:56:01


This is my first day using Access. The data I am using is specialized, but
my problem is analogous to this. I have a table, call it "Player table" with
an "ID" key field, and "Name" and "Position" fields (which are populated via
lookups to single columns of other tables, say a "Name table" and a "Position
table"). I have a second table (call it "Team table") by which I want to
assign players to teams, so, in addition to an ID key field, I have a
"Player" field in which I want to be able select "Smith - QB", for example --
that is, select a record in the Player table and show the Name and Position
fields, which should be linked together. I have been trying for hours to
enter the correct SELECT text for the "Player" field. I seem to have the
concatenation working, except instead of showing "Smith - QB" as an option in
the list boc, it shows "1-3" -- that is, the ID values. What am I doing
wrong?!?? Thanks
 
 
 

Lookup Yielding Key Field Values Instead of Desired Field Values

Post by John W. Vi » Sun, 22 Feb 2009 09:20:53

On Fri, 20 Feb 2009 14:56:01 -0800, newt < XXXX@XXXXX.COM >



All you're doing wrong is trusting Microsoft to have been reasonable in their
design. They weren't. See http://www.yqcomputer.com/
critique of what many of us consider a misfeature.

The field in your table does NOT contain a name. It only appears to do so; the
field actually contains the numeric PlayerID field. You'll need to create a
query joining your table to both lookup tables - which is where the names
actually exist - and concatenate *those* fields.
--

John W. Vinson [MVP]