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.
