after running query table shows id number not name how to fix

[Guest]

I have a table that is in the correct format. When I run a append query
against this table the format is off, there is a number where there should be
text. How do I fix this.

 

[Michel Walsh]

If both fields exist, the ID and the 'formatted name', and you see the id
while you expected to see the formatted name, you may have lost the
'auto-lookup' feature, in the TOOL you are using. Check ELSEWHERE to see if
the auto-lookup still works there. If so, well, use the 'view' showing the
translated id by its formatted name, or use a query that does the lookup
(with a JOIN, or something similar).


Vanderghast, Access MVP

 

[Jason Lepack]

http://www.mvps.org/access/lookupfields.htm