#db.py
db.define_table('customer',
Field('firstname', label = "First Name"),
Field('lastname', label = "Last Name"),
)
db.define_table('cheque',
Field('customer_id', 'reference customer'),
Field('cheque_sent', 'boolean'),
Field('cheque_value', 'double'),
)
#default.py
def test_view():
query = (
(db.cheque.customer_id == db.customer.id) &
(db.cheque.cheque_sent == True)
)
fields = [
db.customer.lastname,
db.cheque.cheque_sent,
]
cheques = SQLFORM.grid(query=query, fields=fields)
return dict(cheques=cheques)