[web2py] Re: best practice for create table base on user insert

2017-07-26 Thread 黄祥
yes, the new tables same for all which is base on detail_coa. the idea is to separate it is base on the case e.g. user input data on chart_of_account table e.g. : -cash -bank a -bank b the same thing goes for account table that automatically create chart_of_account table to maintain the data of

[web2py] Re: best practice for create table base on user insert

2017-07-26 Thread Anthony
Is detail_coa the same or nearly the same for all of these tables? If so, do you really need separate tables, rather than a single table that simply includes an extra field on which to partition it? On Tuesday, July 25, 2017 at 11:12:34 PM UTC-4, 黄祥 wrote: > > let say i have table that will crea