Hello, I'm having difficulty getting inserts to work with tables that have references and I'm sure its something stupid I'm doing wrong. Hopefully you guys can point me in the right direction. I have the following 2 tables.
db.define_table('event_users', Field('event', 'reference events'), Field('user_name', 'reference auth_user'), Field('goal', 'double'), Field('last_entry', 'date'), format = lambda row: "%s - %s" % (row.event.name, row.user_name.first_name)) db.define_table('entries', Field('user', 'reference event_users'), Field('date_entered', 'date'), Field('value', 'double'), format='%(user)s %(date_entered)s') I'm trying to insert a record into the entries table. I have the following SQLFORM to generate the view and then try to pre-populate date_entered and user. User is calculated and is equal to Reference form = SQLFORM(db.entries) form.date_entered = date.today() form.user = user if form.process().accepted: But the form won't submit. When I debug it through Eclipse it says "lazyT: value not in database" Any suggestions? thanks Adrian