db.define_table( 'auth_user', Field('id'), Field('first_name', type='string', label=T('First Name')), Field('last_name', type='string', label=T('Last Name')), Field('email', type='string', label=T('Email')), Field('password', type='password', readable=False, label=T('Password')))
db.define_table( 'sale', Field('id', db.auth_user, default=auth.user_id), Field('start_date', 'date', requires=IS_DATE()), Field('end_date', 'date', requires=IS_DATE()), Field('start_time', 'time', requires = IS_TIME()), Field('end_time', 'time', requires = IS_TIME())) db.define_table( 'product', Field('sale_id', db.sale), Field('name', requires = IS_NOT_EMPTY()), Field('price', 'double', default=0.00), Field('description','text'), Field('image', 'upload', default=''), format = '%(name)s %(price)s') def sale(): form = SQLFORM(db.sale) if form.process().accepted: response.flash = 'Auction Created' redirect(URL('properties')) return dict(form=form) In the above code, I have 3 db tables in the db.py file (user, sale and product). In addition, I have defined the 'sale' function in the default.py file in the controller. The issue that I am experiencing is that when I create a new sale, the user id shows up in the sales form, but when I submit the sales form and redirect to the product form, the sale id field is blank. I thought the "Field('sale_id', db.sale)," would have reference the sale id in the product form. What am I missing? -- 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/groups/opt_out.