Unfortunately not out of the box. You need a custom button that does a ajax query.
On Friday, 3 March 2017 17:52:30 UTC-6, 黄祥 wrote: > > is it possible to edit or delete child or detail table on SQLFORM.grid > with left join? > i've tried before it seems the edit is for the first table (parent or > header), the child or detail table cannot be edited or deleted with left > join in SQLFORM.grid. > *e.g.* > def report_production_result(): > table_header = db.production_result_header > table_detail = db.production_result_detail > > orderby = ~table_header.id > left = table_detail.on(table_header.id == > table_detail.production_result_no) > fields = [ > # header > table_header.id, table_header.production_result_no, > table_header.production_result_date, > table_header.shift, table_header.origin, table_header.status, > # detail > table_detail.stock, table_detail.quantity] > grid = SQLFORM.grid(table_header, fields = fields, left = left, orderby = > orderby) > return locals() > > thanks and best regards, > stifan > -- 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/d/optout.
