Good point! It should be the first table mentioned in the query but, this could be customizable. Please open a ticket about this.
On Thursday, 11 July 2013 12:47:42 UTC-5, Jim S wrote: > > 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 > <massimo....@gmail.com<javascript:> > > 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 >> web2py+un...@googlegroups.com <javascript:>. >> 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.