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]