Create Table Query: query pulling mix of unique ID and name

[dswift]

I am trying to make a "create table query". The purpose of this new query is to look at a larger table, and only pull client name; Analyst; and Reviewer. When I look at the query datasheet view, everything looks fine, but when I "run" the query and the new table is created, I run into issues. Under the "Analyst" column, I only see the unique ID instead of employee name. Under the "review" column, some of the employee names show, but others show as the unique ID (for example, employee 9 always shows up as '9', and the rest of the reviewers names show). In the underlying table, the name (not unique ID) is shown.

CLIENT NAME	ANALYST	REVIEWER
Client A	3	Michael
Client B	4	Lisa
Client C	2	Melissa
Client D	7	9

<tbody>
</tbody>

 

[dswift]

I think my underlying table had some input errors - still not sure exactly how it happened but when I changed them there it seemed to work better in the append query. Then I had some trouble with sorting but after reading the articles you provided I was able to realize it was having to do with the bound column I had selected. So now, all the data is displaying correctly and the sorting functions are working in my appended table - which is excellent. Also using the append table works out much better since I will not need to modify the table each time. Even if I end up deleting rows that are no longer needed for the benefit of the users, I think this will end up being the best way. All the basic functionality that I wanted to achieve is working correctly, just a few little tweaks and I think I will have what I was looking for.