[web2py] Edit button behavior with sqlform.grid and multiple joins

[Jason Martens]

Hello All,
   I have a SQLFORM.grid with multiple joins that looks something like this:

query = (db.locations.id == 10) & (db.rooms.id == db.locations.room_id) & 
(db.other.id == db.rooms.other_id)
SQLFORM.grid(query)

The problem is the edit button defaults to the other table, and I want it 
to go to the rooms table to edit the room details.  How can I fix this?

Thanks,
Jason


--