Hello, I have a model with 2 tables with a "reference" relationship between the two. => the Budget has a type and the name/attributes of this type are defined in the budget_types table.
Now in a query on the budget table i would like to retrieve the name of the Budget type and not the Budget Type id. My model is: db.define_table('budget_types',Field('name','string'),Field('description','string'),format='% (name)s') db.define_table('budgets',Field('name','string'),Field('monthly_amount','double'),Field('type',db.budget_types),Field('view_order','integer'),format='% (name)s') My current query is : budget_list= db().select(db.budgets.id,db.budgets.name,db.budgets.type,db.budgets.monthly_amount,orderby=db.budgets.view_order).as_list() I was thinking about doing budget_list= db().select(db.budgets.id,db.budgets.name,db.budgets.type.name,db.budgets.monthly_amount,orderby=db.budgets.view_order).as_list() but it fails. I guess i could do this with an explicit join but i thought there was a "related" feature like in django ;-)