Results 1 to 6 of 6
  1. #1
    Layman is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2016
    Posts
    3

    Dictionary in Access: problem concerning relation

    Hello there,



    I'm very interested in languages and learning, so I decided to make my own little dictionary in access. I've had a very basic course on Access 2016 so I've mostly made queries and forms on existing databases. The problem with the dictionary is that I can't immediatly think of a way to make relations (that work) so that I can for example make a list with dutch words only.

    What I made so far is about 8 tables with 50 different words in 6 different languages. I'm making different tables so I can group them by theme and that I can print a couple of pages every time I finish the translation of 50x6 words...

    So the question is: how would you make the relations in this database?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make a translation table
    [english],[dutch]

    join on the column, replace the word.

  3. #3
    Layman is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2016
    Posts
    3
    I'm afraid I didn't quite understand your reply.

    I'll add example pictures of how my tables look like in both regular and design display

    Click image for larger version. 

Name:	v1_1.PNG 
Views:	15 
Size:	7.1 KB 
ID:	25606

    Click image for larger version. 

Name:	v1_2.PNG 
Views:	15 
Size:	10.6 KB 
ID:	25607

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I'd recommend a table such as
    Code:
    entry           10    Text    50    
    id                10    Long    4    
    langCode    10    Long    4

    with data such as
    entry id langCode
    cat 1 1
    chat 1 2
    elgato 1 3
    dog 2 1
    chien 2 2
    elpooper 2 3
    horse 3 1
    cheval 3 2
    caballo 3 3

  5. #5
    Layman is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2016
    Posts
    3
    Quote Originally Posted by orange View Post
    I'd recommend a table such as
    Code:
    entry           10    Text    50    
    id                10    Long    4    
    langCode    10    Long    4
    What kind of way is that to organize your table? I haven't seen a similar screen, is there a topic on using it?


    Thanks for the link in your signature anyway, that's helped me in another database

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Code:
    entry           10    Text    50    'the word in the language of lang_cd
    id                 10    Long    4    'the unique id of the word
    langCode    10    Long    4    'the code for the specific language
    
    Lang_cd  language
    1             English
    2             French
    3             Spanish
    
    with data such as
    
    entry    id    langCode
    cat         1    1
    chat       1    2
    elgato    1    3
    dog        2    1
    chien     2    2
    elpooper    2    3
    horse      3    1
    cheval     3    2
    caballo    3    3
    This makes for a simple dictionary to translate words from one language to another.

    I'd probably call it a lookup table also. Lookup a word in a specific language, and get that word in a different language.

    eg. What is the Spanish word for the English word "Horse"?

    Lookup Horse in English, get the value with the same Id number, and lang_cd for Spanish.

    Good luck with your project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. query with relation in tables problem
    By JeroenMioch in forum Access
    Replies: 4
    Last Post: 04-01-2016, 03:06 AM
  2. Replies: 4
    Last Post: 07-29-2013, 10:52 PM
  3. Problem in creating data dictionary using VBA
    By coolpal9 in forum Database Design
    Replies: 1
    Last Post: 03-01-2013, 01:47 AM
  4. Data Dictionary:
    By momodoujimnjie in forum Access
    Replies: 2
    Last Post: 12-18-2012, 02:30 AM
  5. Data dictionary
    By Rohit0012 in forum Access
    Replies: 2
    Last Post: 11-24-2009, 03:08 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums