Re: Query 8 Tables no Primary Key

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"fix my problem"... You didn't state your problem. A WAG is that you have a
number of tables with the same basic structure. Another WAG is that Emp#
should be a primary key in an employee table and foreign key in other
tables. Another WAG is that you can add an autonumber field to create a
primary key in any table.
--
Duane Hookom
MS Access MVP

<MonkeyKunkel@xxxxxxxxxxx> wrote in message
news:1147441908.832186.116530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Can someone tell me how to query 8 tables with a common, not primary
key, field of Emp#?
My tables cant have a primary key because of duplicates. If someone has
an idea how I can fix my problem I would be grateful. Example of 1
table and data. The tables all have the smae number of fields but
different names.

Table Design:

Table: Cutting
Field 1: Emp#
Field 2: Cable type
Field 3: Date Trained
Field 4: Skill Level

Example of table data:

Table: Cutting
EMP Cable Date Skill Level

12345, yellow, 5/5/06, beginner
12345, blue, 5/7/06, beginner
11111, yellow, 5/5/06, skilled
12121, red, 5/5/06, beginner



.

Relevant Pages