grid can only edit one table. smartgrid can edit referenced tables but not join them. Unfortunately we cannot support both because logically it would be too complex. You can create your own custom button.
On Thursday, 11 July 2013 09:02:09 UTC-5, Jim S wrote: > > I have a controller method with a SQLFORM.grid in it. > > The following setup: > > > query = db.pricingIngredient.pricingIngredientId > 0 > left = > [db.productSite.on(db.pricingIngredient.productSiteId==db.productSite.productSiteId), > db.site.on(db.productSite.siteId==db.site.siteId), > db.product.on(db.productSite.productId==db.product.productId)] > > grid = SQLFORM.grid(query, left) > > When I click on the edit button I want to edit the pricingIngredient > table. However, SQLFORM.grid is taking me to edit the product table. > > Is there a way to override this and force it to edit the pricingIngredient > table without coding my own custom edit button? > > -Jim > > -- --- 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.
