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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]CLIENT NAME[/TD]
[TD]ANALYST
[/TD]
[TD]REVIEWER
[/TD]
[/TR]
[TR]
[TD]Client A
[/TD]
[TD]3
[/TD]
[TD]Michael
[/TD]
[/TR]
[TR]
[TD]Client B
[/TD]
[TD]4
[/TD]
[TD]Lisa
[/TD]
[/TR]
[TR]
[TD]Client C
[/TD]
[TD]2
[/TD]
[TD]Melissa
[/TD]
[/TR]
[TR]
[TD]Client D
[/TD]
[TD]7
[/TD]
[TD]9
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.