something like this? SQLFORM.grid(db.table1.field1==db.table2.id,fields=db.table1.ALL,orderby=db.table2.field2)
smartgrid cannot do this. On Monday, 21 May 2012 15:24:23 UTC-5, backseat wrote: > > Thanks Jim, I somehow missed the 'orderby' parameter to SQLFORM.grid > > On Mon, 21 May 2012 13:11:31 -0700 (PDT), massimo.dipierro@gmail.comsaid: > > > 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? >