Make Table

[Andy]

I have set up a Select Query to display a number of Order related fields from various tables. When I run the select query the customer names are displayed from a linked Customers table. When I change this query to a Make Table query the new table contains the the primary key from the customers table instead of the name.

How do i get the query to create the new table with the customer names not customer ID?

Thanks