Wednesday, February 29, 2012

Hi, I want to map English words to Tamil words using MS Access for a translator project.How to do it ? help?

Hi i want to have both the english words mapped with its corresponding tamil words in MS Access. I am a student working on Translator Project ... So pl help me to solve.


Thanks in advance|||I would use 2 tables, depending on which language You are most familiar with.


TAMIL_TBL and ENG_TBL


TAMIL_TBL has fields WORD_ID and WORD_PHRASE


ENG_TBL has WORD_ID, TAMIL_ID, and WORD_PHRASE





In the RELATIONSHIPS view link TAMIL_TBL.WORD_ID to ENG_TBL.TAMIL_ID with a One to Many.





Build a form that allows You to view each TAMIL WORD in TAMIL_TBL one at a time, and has a SUBFORM that shows all the related ENG_TBL WORD_PHRASE.





The reason for this is that languages don't always have a word-for-word translation. Greek for example has like 4 or 5 words for "love" (and additional words for "lust" etc...), so it would require a PHRASE like "Love for your Family", "Love for Food", "Love for Women", "Love for Your Wife", etc... Spanish has 2 completely different words for "Key", one for "Musical" and one for "Locks"...

No comments:

Post a Comment