never mind, I got it working, by modifying candidate =db(db.words.word.lower()==trans_form.vars.word.lower())(db.words.lang==trans_form.vars.languages).select().first()
to candidate = db(db.words.lang==trans_form.vars.languages).select().find(lambda x:x.word.lower()==trans_form.vars.word.lower()).first() I opened this discussion because (If I remember it correctly), I didn't got candidate = db(db.words.word.lower()==trans_form.vars.word.lower()).select().find(lambda x:x.lang==trans_form.vars.languages).first() to working in the first place. (note find is changed)
