Hello. Sorry for maybe dumb question, but I have simple situation: Two tables something like that:

db.define_table('category',
   Field('name'))

db.define_table('expenses',
   Field('amount', 'double'),
   Field('id_category', db.category, required=False),
   Field('user'))

I want to display expenses.amount and category.name in one table, but only from specific user. When I use db(db.expenses.id_category==db.category.id), I can easily display field category.name, but it displays records from all users. When I use db(db.expenses.id_users=='user'), it selects records from specific user, but it only displays expenses.id_category. Tried expenses.id_category.name - doesn't work.