And of course I find it within a minute of posting... lol Here is my solution:
in model: db.define_table('table2', Field('field1','reference table1'), Field('field2','reference table1', requires=IS_IN_DB(db, db.table1.id, '%(field2)s')), migrate=False) in controller: db.table2.field2.represent = lambda s,r: s.field2 grid=SQLFORM.smartgrid(table2) return dict(grid=grid) Hope this helps someone in the future. Time for beer! On Friday, September 4, 2015 at 4:49:31 PM UTC-4, LoveWeb2py wrote: > > I've been struggling with this for hours! > > db.define_table('table1', > Field('field1', 'string'), > Field('field2','date'), > format='%(field1)s %(field2)s', migrate=False) > > db.define_table('table2', > Field('field1','reference table1'), > Field('field2','reference table1'), > migrate=False) > > I'm trying to show table2 in a SQLFORM, but it only shows the field 1 > values, for both fields. I want to show field 2 values in table 1 for > table 2. In SQLFORM.grid it only returns the id instead of the grid. > > I'm so frustrated! > > I've tried: > https://groups.google.com/forum/#!topic/web2py/bO1N4r2j0Dg > > http://stackoverflow.com/questions/1012179/how-to-generate-a-many-to-many-relationship-form-in-web2py > http://markmail.org/message/usmvxp5zctssog7d > > > Any advice is greatly appreciated. I'm sure it's something simple, but I > just can't seem to find it. > -- 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.