Autonumber as Primary Key and Relationships

C

cmc096

Joined
Jun 29, 2009
Messages
1
Reaction score
0
I have created several tables that all have data that is similar: name, address, phone number and other data. The problem is they do not really have any unique data to be set as the PK. What I have done in order to attempt to correct the problem is set an autonumber field for each table and use that as the PK. I set the relationships up using this field. The problem I am having is if I enter data in one table and go to the next and enter data the autonumbers are not matching up.
 

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

Autonumber as Primary Key and Relationships 13
Look up tables vs. relationships design 1
Table Design and Relationship issues 5
Many to Many with AutoNumber PK 4
Data Primary key vs. Artificial (Autonumber) primary key 78
Change primary key from autonumber to text field? 1
autonumber relationship 5
Defining Relationships/Primary Keys between two tables 3

Top