[web2py] Re: Please help me to design my database structure

2013-09-10 Thread Andreas Wienes
Each steps from table project_type_step should be copied to table project_step, after creating a new project through the form. Am Dienstag, 10. September 2013 11:16:33 UTC+2 schrieb Luc Chase: > > You want to copy all the steps... then mark each as it is done? Or are you > wanting to create each

[web2py] Re: Please help me to design my database structure

2013-09-10 Thread Luc Chase
You want to copy all the steps... then mark each as it is done? Or are you wanting to create each done project_step record only after it is done? On Tuesday, 10 September 2013 00:02:40 UTC+1, Andreas Wienes wrote: > > Thanks for your advice! I corrected the small error and created the new > ta

[web2py] Re: Please help me to design my database structure

2013-09-09 Thread Luc Chase
You have thought of the correct solution ( I would call it project_steps ) . On Monday, 9 September 2013 17:12:04 UTC+1, Andreas Wienes wrote: > > Hello, > > I've three models called project, project_type and steps. > > A project belongs to a certain project_type and depending on what kind o

[web2py] Re: Please help me to design my database structure

2013-09-09 Thread Andreas Wienes
Thanks for your advice! I corrected the small error and created the new table. Now I'm trying to copy the steps for a specific project_type to a new created project. I tried the following: def start(): form = SQLFORM(db.project).process() if form.accepted: project_type = form.va