Thanks for the reply Massimo. I know grid can only edit one table and that is what I want. I'm just wondering how it chooses which table it is editing if the left parameter is specified. Also, in my example above, it should be
grid = SQLFORM.grid(query, left=left) -Jim On Thu, Jul 11, 2013 at 12:08 PM, Massimo Di Pierro < [email protected]> wrote: > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/Yl-6-oYA9C4/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- --- 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.
