I think you need to flip it around, and use facilities instead of servers, and then you will get the link to servers:
facilities = SQLFORM.smartgrid(db.facility, linked_tables={}, user_signature=False, links_in_grid=True, editable=False, deletable=False) return dict(facilities=facilities) On Tue, Sep 25, 2012 at 5:06 AM, Dominic Cioccarelli < dominic.cioccare...@gmail.com> wrote: > Hi all, > > I'm having some difficulties with smartgrid and linked tables. My model is > as follows: > > db.define_table('facility', > Field('facility_id','id'), > Field('name'), > Field('type'), > migrate=False) > > db.define_table('server', > Field('server_id','id'), > Field('server_name'), > Field('facility_id', db.facility), > Field('active', 'boolean'), > Field('modified_date', 'datetime'), > migrate=False) > > Note that because it is an existing database, the primary key is not > called "id" in the database but is defined as an ID type in the model. Not > sure if this is important. > > The controller is as follows: > > def index(): > response.flash = "Welcome to the server view!" > linked_tables = ['facility'] > servers = SQLFORM.smartgrid(db.server, linked_tables=['facility'], > user_signature=False, links_in_grid=True, editable=False, deletable=False) > return dict(servers=servers) > > When the table renders, it doesn't display hyper-links for the facility > IDs as I would have expected. > > Am I missing something? > > Ciao, > Dominic. > > -- > > > > --