[web2py] web2py sqlform.grid join problem

2015-01-03 Thread Roman Rakus
Hi, I have folloving tables. db.define_table('tbl1', Field('code', 'string')) db.define_table('tbl2', Field('field1', 'integer', 'reference tbl1'), Field('field2', 'integer', 'reference tbl1')) Now I need render values from tbl2 in sqlform.grid. How I can join tbl2.field1 and tbl2.field2 on

[web2py] sqlform.grid with double join

2015-01-03 Thread Roman Rakus
Hi, I have folloving tables. db.define_table('tbl1', Field('code', 'string')) db.define_table('tbl2', Field('field1', 'integer', 'reference tbl1'), Field('field2', 'integer', 'reference tbl1')) Now I need render values from tbl2 in sqlform.grid. How I can join tbl2.field1 and tbl2.field2 on