Hi Tom, I think you need to specify the join between the two tables in the query, otherwise you get the full product of the two tables. Please check the Web2py book at http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Inner-joins
Please show the model files if you need more help. Nico de Groot -- 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.
