[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-13 Thread Ramesh Meda
Peter, I really appreciate members of this group being active and willing to help. Peter, everybody is learning, at different levels. Thank you for helping and look forward to your support in future. Regards, Ramesh On Thursday, July 13, 2017 at 6:32:50 AM UTC+5:30, Peter wrote: > > > Correc

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-12 Thread Peter
Correct Ramesh, That is for viewing the invoice details on screen after the Invoice has been created (taking information from an Invoice_header table and related records in the Line_items) but the Invoice Preview provided to the user appears identical (although the information comes from the C

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-12 Thread Ramesh Meda
Dave, Thanks much for the info. Regards, Ramesh. On Wednesday, July 12, 2017 at 7:44:12 AM UTC+5:30, Dave S wrote: > > > > On Tuesday, July 11, 2017 at 7:07:56 PM UTC-7, Peter wrote: >> >> Hi Ramesh, >> >> I return a crud.read() for the invoice header and a separate query output >> for the in

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-12 Thread Ramesh Meda
Peter, Thank you, that could work for reading invoice. I guess it might require a bit more for accepting / creating new invoice... or do I get this wrong. Regards, Ramesh. On Wednesday, July 12, 2017 at 7:37:56 AM UTC+5:30, Peter wrote: > > Hi Ramesh, > > I return a crud.read() for the invoi

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-12 Thread Ramesh Meda
Dave, Thank you and could you post some code please... Regards, Ramesh. On Wednesday, July 12, 2017 at 4:56:14 AM UTC+5:30, Dave S wrote: > > > > On Monday, July 10, 2017 at 9:15:08 PM UTC-7, Ramesh Meda wrote: >> >> Dave, Thank you and appreciated. But, my question was about forms and not >>

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-12 Thread Ramesh Meda
Stifan, Thank you, will try that approach. :) Regards, Ramesh. On Tuesday, July 11, 2017 at 12:45:47 PM UTC+5:30, 黄祥 wrote: > > in form side, > everything in 1 page i usually use web2py load components: > first component is an sqlform.factory() to select the invoice_items > second component

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-11 Thread Peter
Thanks for correcting this Dave. (Will have to read up on components). Peter -- 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 messa

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-11 Thread Dave S
On Tuesday, July 11, 2017 at 7:07:56 PM UTC-7, Peter wrote: > > Hi Ramesh, > > I return a crud.read() for the invoice header and a separate query output > for the invoice lines. > > Note that the crud interface is deprecated, and isn't getting maintenance (possible exception for security fixes)

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-11 Thread Peter
Hi Ramesh, I return a crud.read() for the invoice header and a separate query output for the invoice lines. My approach is to store all Invoice Header info in a separate table on Invoice creation. (This is to ensure that an exact copy invoice can be reproduced at any later date and is not affe

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-11 Thread Dave S
On Monday, July 10, 2017 at 9:15:08 PM UTC-7, Ramesh Meda wrote: > > Dave, Thank you and appreciated. But, my question was about forms and not > database. How could one develop a page that has one invoice row and > multiple item rows... > Like Stifan, I would use ajax/load/component stuff.

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-11 Thread 黄祥
in form side, everything in 1 page i usually use web2py load components: first component is an sqlform.factory() to select the invoice_items second component is a view for for invoice_item and third component is sqlform that rever to invoice_header ref: http://web2py.com/books/default/chapter/29/

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-10 Thread Ramesh Meda
Dave, Thank you and appreciated. But, my question was about forms and not database. How could one develop a page that has one invoice row and multiple item rows... -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - http

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-10 Thread Dave S
On Monday, July 10, 2017 at 12:56:58 PM UTC-7, Ramesh Meda wrote: > > What would be the best approach to develop Parent-Child forms in Web2Py > please... > > Case in point... lets say, simple invoice application (over simplified for > the sake of discussion) > Invoice Header (Parent), with inv