Make Table

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Chart on form from selected data in query. 0
QBF & Query Malfunction 0
List all tables, including document structure 0
Make table query: [Enter 1] AS Test 1
Help with a "like" query between two fields from two different tables... 2
Total appointments per agent 2

Top