Hello

Suppose we have the following:

#Model:
table_1 = db.define_table('table1',    
    Field('name'),
)



table_2 = db.define_table('table2',
    Field('field1'),
    Field('field2', table_1),
)


#Controller:

def something():
    grilla = SQLFORM.smartgrid(table_1)



this shows me the grid with records from table1 and a link to another grid 
with table2 records. This is correct.

But if I do the following:

def something():
    grilla = SQLFORM.smartgrid(table_1, orderby= table_1)


The first grid shows good and well ordered, but when trying to display 
records from table2 through the link, can't get the records because it is 
sort of a field belonging to table1

*Query Not Supported: no such column: table1.name*
*
*

Jose

-- 



Reply via email to