If you are in 'edit' mode in your SQLFORM.grid, set the default value for
that field equal to the value for your order.
if request.args(0) == 'edit':
db.order_items.order_id.default = request.args(2)
Place this BEFORE your grid = SQLFORM.grid(...)
-- not tested --
-Jim
On Wednesday, March 13, 2013 4:52:34 PM UTC-5, Jeison Dück wrote:
>
> Hello, all,
>
> I have those 3 models bellow:
>
> db.define_table('order',
> db.Field('customer', db.customer),
> db.Field('autor', db.auth_user),
> db.Field('created', 'datetime'),
> )
>
> db.define_table('product',
> db.Field('name'),
> db.Field('value'),
> format='%(name)s'
> )
>
> db.define_table('order_items',
> db.Field('order_id', db.order, required=True),
> db.Field('product_id', db.product, required=True),
> db.Field('amount', 'integer', required=True, default=1),
> db.Field('value','decimal(20,2)', required=True, default=0),
> db.Field('total', compute=lambda r: (float(r['preco'] * r['quantidade'])
> )
>
>
> They are displayed as form for order record and bellow a SQLFORM.grid for
> displaying order_items.
> Is there a way for setting default value for order_items.value to be the
> same as product.value, from parent table?
>
> Also, is it possible to add a row for totals for a column?
>
>
> Thanks for any suggestion
>
>
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
