Thanks for the advise. Yes you are right i didnt need the join, was just following the same pattern as other queries which does need them, not this case.
Also right with virtual fields, they are easy to use but i dont think i should write tens lines of code within a lambda. My webapp is getting big and i need a way to organize the code. I also didnt want to mix logic with table definitions. Thank you very much for your help. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.

