Hi, I solved it putting the foreing key format in the controller, before the grid:
def familia_manage(): *db.auth_user._format = '%(last_name)s %(first_name)s'* fields=[db.t_familiares.f_nombre, db.t_familiares.f_apellidos,db.t_familiares.f_titular] form = SQLFORM.grid(db.t_familiares, fields=fields ) return locals() Where, in the table declaration: db.t_familiares.f_titular.requires= (IS_IN_DB(db,'auth_user.id','%(last_name)s ''%(first_name)s')) When I press the header I get it order by last_name instead of id. El lunes, 21 de mayo de 2012 22:24:23 UTC+2, backseat escribió: > > Thanks Jim, I somehow missed the 'orderby' parameter to SQLFORM.grid > > On Mon, 21 May 2012 13:11:31 -0700 (PDT), massimo....@gmail.com > <javascript:> said: > > > foreign key. You can do a join. > > Thanks Massimo; however, that's a little cryptic. Could you explain how a > join can be used to determine the sort order when I click on a > SQLFORM.grid header? > > Thanks, > Keith > -- > "You can have everything in life you want if you help enough other people > get what they want" - Zig Ziglar. > > Who did you help today? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.