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.

Reply via email to