In addition to all the other little projects I'm working on to try and learn VB(express edition), I've decided to try and build an English/Spanish translator. I'm looking for suggestions as to what might be the better route to take as far as treating the retrieval of the translated text from the database that I'm building. For example, when the user enters in the english phrase(or word), the form would return the spanish equivalent (doing more of a literal translation, rather than trying to work out all the nuances of proper grammar).
I'm sure this could probably be accomplished by using a metric poo-ton of If/Then/Else statements, but I would be willing to bet there would be a much cleaner way of doing this. Suggestions? (I'm not looking for someone to do the code for me, just a nudge in the right direction)
As always, Thanks in advance.