Relationship between 2 tables - how to link

  • Thread starter Continental Translations
  • Start date
C

Continental Translations

I have a contact details table which has autonumber as the primary key, so
each individual has an automated number. Now, i want to create a new table
which will list a source language and a target language. What should I set
as my primary key though? Source language? Target language? or add an
additional field such as language pair. Some of my contacts will have the
same source language and target language and so they will be used more than
once.

This combination milarkey is really confusing me!

Thanks
 
D

Dirk Goldgar

Continental Translations said:
I have a contact details table which has autonumber as the primary
key, so each individual has an automated number. Now, i want to
create a new table which will list a source language and a target
language. What should I set as my primary key though? Source
language? Target language? or add an additional field such as
language pair. Some of my contacts will have the same source language
and target language and so they will be used more than once.

This combination milarkey is really confusing me!

Thanks
Click to expand...

Look at the reponses to your earlier messages. Please have a little
patience, and don't post the same questions over and over again in a
short time frame -- newsgroups aren't chatrooms, and it may take a while
for someone to read your question, come up with an answer, and get
around to posting it. As it is, you're starting so many hares, you're
going to have a hard time chasing them all down.
 
Top