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"...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment