Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2013
    Posts
    35

    Unanswered: Dictionary Design

    How can design Dictionary on Access We need to how the table so that if the translation is English and Arabic, Arabic and English

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Have a table
    Tables resources
    Phraseid pk
    Langid pfk
    Phrase
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2013
    Posts
    35
    Thank You My Dear Teacher
    My Dear Teacher possible to clarify more or if possible to operate me an example of design tables be thankful to you

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by healdem View Post
    Have a table
    Table resources
    Phraseid pk autonumber
    *Langid pfk long
    Phrase text (as long as you need for your phrases/sentances
    LangID is part fo the primary key in Resources and is also a foreign key to ID in languages

    table Languages
    ID autonumber PK
    description text(50)
    if you would prefer a more common design using the 4/5 digit code that identifies the language and the country then instead of using an autonumber define the language id as text (5). such language . country combinations include
    EN-UK
    EN-US
    FR-FR
    FR-CA
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Oct 2013
    Posts
    35
    Very Very Thank You My Dear Teacher
    My Dear Teacher
    I will design the tables

    1)
    Table resources
    Phraseid pk autonumber
    Phrase text
    LangID

    2)
    table Languages
    ID autonumber PK
    description text(50)

    Is this correct tables
    Last edited by azizsader; 11-03-13 at 13:07.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •