pbreit, As you say, wherever possible or required, I have already denormalized the table-structures. Apart from normalization / denormalization issue, in many other forms, I need to insert/update/delete records in multiple tables from one form. (as I mentioned earlier, there will be a mix of insert/update/delete of record(s) in different tables.)
Massimo, If you too haven't understood what I intend to do with these 5 tables, I can elaborate the idea. Pl. tell me accordingly. The very success of developing my project using web2py hinges on this functionality. ---Vineet ================================================ On May 11, 5:17 am, pbreit <pbreitenb...@gmail.com> wrote: > Normalizing is not always the best approach. If the database has not yet > been designed, perhaps reconsider. I still don't really understand what you > are trying to do but 5 small tables might not be necessary. > > I would suggest getting some code working with 2 tables an then go from > there. > > Some > options:http://web2py.com/book/default/chapter/07#One-form-for-multiple-tableshttp://web2py.com/book/default/chapter/07#Multiple-forms-per-page > > Another approach would to use FORM or SQLFORM.factory and then coding the > database updates. You lose some of the Web2py features but it might still be > the easiest way to do it. > > But my first suggestion would be to try and simplify what you are intending > to do.