[web2py] Re: sqlform.grid add new - populate some fields(with values from another db) based on other fields

Thanks. Noted that, thats the best way and might be the only way On Sunday, 22 June 2014 12:53:51 UTC+3, 黄祥 wrote: sorry, didn't read this sentence I want these to be reflected even before i click 'submit' button if you want to achieve it before click 'submit' button, i think you can

[web2py] Re: sqlform.grid add new - populate some fields(with values from another db) based on other fields

1. when i select itemcode from dropdown, the form to fill itemname and sellingprice from the stockitems table i think you can achieve it using form.validate(), use query for stockitems table and then insert itemname and sellingprice base on the row of stockitems 2. when i enter qty,

[web2py] Re: sqlform.grid add new - populate some fields(with values from another db) based on other fields

sorry, didn't read this sentence I want these to be reflected even before i click 'submit' button if you want to achieve it before click 'submit' button, i think you can achieve it using ajax callback for that. best regards, stifan -- Resources: - http://web2py.com -