Relationship

  • Thread starter Thread starter Continental Translations
  • Start date 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
 
I do not understand what you need to do. What is in the
Contact Details table? What is the purpose of the new
table for listing the source and target language? Do you
want to add source and target language to the contact
details table? In that case you would probably do best to
have a language table (or better yet, a query based ont he
table) as the row source for a combo box from which you
select a language.
Nothing you have presented so far indicates the need for a
combined primary key, unless for some reason you can't
have a records with the same source and contact language
combination as in any other record.
When you say that you need a new table for source and
target language I start to wonder about your database
structure. Why don't you back up a bit and explain more
about your database structure and what you need the
database to do?
 
OK, lets start from the beginning as I agree I am not making much sense.

What i'm after is a database do keep a list of all my freelance translator
and their contact details (name, address, telephone number etc.....) All of
my contact entries will be automatically given a Contact ID (that being my
primary key for this table) Now, for each freelance translator, they will
each have one or more language pairs, the first language being the 'source'
language and the second being the 'target' language which they work between,
ie French into Spanish and English into Spanish. So, for example, my first
contact, William Brown, will be able to translate between French (source
language) and German (target language), and English (source language) and
German (target language). Now, I am not too sure whether I should put these
language details in the 'Contact Details' table or in a new table. I also
want to be able to add a price per 1000 words that each 'contact' charges.

Eventually, what I want to be able to do, is search on a few principles. For
example, I want to be able to search via surname, source language, target
language, source language AND target language together and price.

Any help??
 
Back
Top