format strings and multiple levels of indirection

[rocket]

Hi,

I have two tables defined like this:

db.define_table('t_client',
Field('f_name', type='string', notnull=True, label=T('Name')),
format='%(f_name)s')

db.define_table('t_project',
Field('f_name', type='string', notnull=True, label=T('Name')),
Field('f_tbte_project_number', type='string', notnull=True,
label=T('TBTE Project Number')),
Field('f_report_to', type='string', notnull=True, label=T('Report
To')),
Field('f_client', db.t_client, notnull=True, label=T('Client')),
format='%(f_tbte_project_number)s %(f_client)s - %(f_name)s')

My issue is when I reference t_project from another table, the format
string includes the record id of the client and not the client's name
string.

What is the way to display the client's name string instead of id from
a third table using best practices?

[rocket]

I think I've found the solution here:
http://groups.google.com/group/web2py/browse_thread/thread/1d94e9bfc9877769

format=lambda r: r.f_tbte_project_number + r.f_client.f_name
+r.f_name