[web2py] record representation format that refer to another table and that table is refer to another table

[黄祥]

hi,

did anyone know how to show record representation format that refer to 
another table and that table is refer to another table?

e.g.
*db.py*
db.define_table('branch',
    Field('address', 'text'),
    Field('zip'),
    Field('city'),
    Field('country'),
    Field('phone'),
    Field('fax'),
    Field('email'),
    Field('company', 'reference company'),
    format='%(address)s')

db.define_table('room',
    Field('room_no'),
    Field('status', 'list:string'),
    Field('branch', 'reference branch'),
    format='%(branch)s %(room_no)s')

db.define_table('booking',
    Field('scheduled_start', 'datetime'),
    Field('due_date', 'datetime'),
    Field('room', 'reference room'),
    Field('customer', 'reference customer'),
    Field('description', 'text'),
    format='%(scheduled_start)s %(customer)s %(room)s')

*my question is:*
when i select table booking, i want to see : branch address room no (e.g. 
jakarta 101), notf branch id room no (e.g. 1 101).

many thanks before

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.