Fixed it by normalizing the tables. I had a duplicate with suppliercode. Thanks
On Tuesday, December 22, 2015 at 3:08:08 PM UTC-8, Anthony wrote: > > db.define_table('supplier', >> Field('suppliercode',requires=IS_UPPER()), >> format='%(suppliercode)s') >> >> db.define_table('series', >> Field('seriesname'), >> Field('seriesdescription',requires=IS_UPPER())... >> >> db.define_table('product', >> Field('series', 'reference series'), >> Field('suppliercode','reference supplier', default=db.supplier.id)... >> >> >> Shouldnt the fields series and suppliercode automatically populate in the >> grid? Right now only series populates itself. >> > > What do you mean by "automatically populate in the grid"? The grid shows > records that have already been inserted. Did the records in question have > the expected values when inserted? > > Note, you do not define a default for the "series" field. Also, the > default for the "suppliercode" field must either be a value or a function > that generates a value -- it should not be a field object. > > Anthony > -- 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.