I was about to do this when I encountered a logical problem...
db.define_table('table1',SQLField('name',label='Name'))
db.define_table('table2',SQLField('name',label='Name'),SQLField
('other_id',db.table1))
{{=db(
db.table1.id==db.table2.other_id).select()}}
this makes a JOIN so the table headers involve two tables.
currently the header is
table1.name,
table2.name
if I use label, the header would be:
Name, Name
because a label makes sense only within the context of a table, not
two joint tables.
the current mechanism is to do
{{=db(
db.table1.id==db.table2.other_id).select()}}
{{=SQLTABLE(db(
db.table1.id==db.table2.other_id).select(),headers=
{'
table1.name':'Fisrt table Name', '
table2.name':'Second Table
Name'})}}
which makes
First Table Name, Second Table Name
is this sufficient? Pros Cons Suggestions?
Massimo