Model: db.define_table('movie', Field('title','string'), Field('api_id', 'string'), Field('average_rating', 'double'), Field('released', 'integer'), Field('mpaa_rating', 'string'), Field('synopsis', 'text'), Field('short_synopsis', 'text'), Field('created', 'datetime','datetime', default=request.now), Field('modified', 'datetime','datetime', default=request.now), format = '%(title)s')
db.define_table('person', Field('name', 'string'), Field('api_id', 'string'), Field('birthday', 'date'), Field('created', 'datetime','datetime', default=request.now), Field('modified', 'datetime','datetime', default=request.now), format = '%(name)s') db.define_table('star', Field('movie_id', db.movie), Field('star', db.person), Field('created', 'datetime','datetime', default=request.now), Field('modified', 'datetime','datetime', default=request.now)) Grid code: @auth.requires_login() def manage_movies(): grid = SQLFORM.smartgrid(db.movie) return locals() Thanks for taking a look. Apologies if this is a really lame mistake. Trust that I do RTFM. On Thursday, August 9, 2012 6:16:58 PM UTC-4, Anthony wrote: > > Can you show the model and grid code? > > On Thursday, August 9, 2012 4:00:06 PM UTC-4, Mike Girard wrote: >> >> Can anyone tell just by looking at this what the problem with the ID and >> Star fields might be? The record is actually fine. When I click Edit, >> everything is as it should be. >> >> Sorry for not providing the full background on this, for brevity's sake. >> Was wondering if someone can see the problem just by looking at this. >> >> >> https://lh6.googleusercontent.com/-eS6fJPgPv5k/UCMiWvEM_7I/AAAAAAAAAAc/NzibaZS3H_Y/s1600/Screen+shot+2012-08-08+at+10.35.52+PM.png >> > --