I am building a select query. My query contains 2 tables: 1 table has product codes and the other has product sales.

Table 1: Product code table - contains these fields and sample records:

Prod_Class Prod_Desc
t Inbound
T Outbound
r Local
R International


Table 2: Product Sales table - contains sales records:

Prod_Class Sales_Qty
t 120
T 20
R 75

Problem: I need to inlcude the Prod_Desc in a select query, however when I link both tables in the query I am getting the incorrect information due to case sensitivity.

How can I solve this problem?


regards,

You need to have a unique primary key for each table and use this a a foreign key in the main table. Access does not allow case sensitivity for primary keys.

Don't know if it helps.... I'm using Access 2007.

Also, I have multiple sales records which will have the same Prod_Class in the sales table. Therefore I won't be able to set a unique primary key in the Sales table, correct?

I would shoot the guy who decided to use case sensitivity in the first place.