REFERENCING

  • Thread starter Continental Translations
  • Start date
C

Continental Translations

I have a column in 2 seperate tables which I want to link. In the first
column, I have peoples contact details and in the second column I have a
list if different languages. How do i go about creating a relationship for 1
person in my contact details to many different languages in my second table?
I know i would have to add another column so as to link it to my contact
number, ie 1 etc...but if they can be linked to several languages, how do i
type it in?
 
B

Brendan Reynolds

I'm having a difficult time trying to visualize what you have at present,
but the relationship between people and languages is logically a
many-to-many relationship - one person may speak more than one language, and
one language may be spoken by more than once person.

Many-to-many relationships are implemented as two one-to-many relationships
via an intermediate table, e.g. a table PersonLanguage might have fields
PersonID and LanguageID (with a unique index on the combination of those two
fields) with a one-to-many relationship between PersonLanguage and Person
(on PersonID) and another one-to-many relationship between PersonLanguage
and Language (on LanguageID).

I don't think there are any examples of many-to-many relationships in the
Northwind example that is bundled with Access, but if you have access to SQL
Server, the pubs database has an example - look at the titles, authors, and
titleauthors tables.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Top