You have two forms both called form (the second overwrites the first one) and you return only one of the
return dict(...,form=form) You should call them form1 and form2 and return both. On Dec 2, 9:52 am, Johann Spies <johann.sp...@gmail.com> wrote: > Maybe I am just tired now. I am struggling to find the mistake and will > appreciate some help please. > > I want to select an ID from one table and use that ID to show the full > record from one table and related records from another table. > > Two problems: > > 1. If I use {{=form}} for the first form in ' show_fipil01' in the view I > get two identical fields/labels on the screen with one submit button. I > could 'solve' this problem using a custom form in the view. > > 2. When I select an id, no redirect takes place and the debugging line > (response.flash=repr(form.errors)) flash 'Storage {}' > I have also tried the redirect with > redirect(URL(r=request, f='show_fpipl01_data',vars=request_vars)) with > the same result. > > My controllers: > > def show_fpipl01_data(): > id = request.vars.id > form = crud.read('fpipl01',id) > data = SQLTABLE(db((db.fpipl01_data.form_id == id) & > (db.teacher.id == db.fpipl01_data.teacher) & > (db.school.id == db.fpipl01_data.school)).select( > db.fpipl01_data.form_id, > > db.teacher.surname, > > db.teacher.name, db.school.name, > > db.fpipl01_data.grade_taught), > headers = {'fpipl01_data.form_id' : 'Form ID', > 'teacher.surname' : 'Teacher surname', > 'teacher.name' : 'Teacher name', ' > school.name' : 'School', > 'fpipl01_data.grade_taught' : 'Grade > taught'}, > truncate = 25) > > message = 'FP/IP Literacy and English: Teacher training attendance > register (FPIPL01)' > return dict(form=form,data = data, message = message) > > def show_fpipl01(): > tabel = request.vars.tabel > tb = tabel.lower() > if auth.user_id in [21,22]: # Johann Spies (22) or ERA (21) > rdata = db((db.service_provider.id == db[tb].service_provider) > ).select(db[tb].id, > db.service_provider.name, > db[tb].date,db.fpipl01.trainer, > db[tb].focus) > > else: > rdata = db((db[tb].created_by==auth.user_id) & > (db.service_provider.id == db[tb].service_provider) > ).select(db[tb].id, > db.service_provider.name, > db[tb].date,db.fpipl01.trainer, > db[tb].focus) > > ids = [] > for row in rdata: > ids.append( row['fpipl01']['id']) > > data = SQLTABLE(rdata, > headers = {'fpipl01.id' : 'ID', ' > service_provider.name' : 'Service Provider', > 'fpipl01.date': 'Date', 'fpipl01.trainer': > 'Trainer', > 'fpipl01.focus': 'Focus of training'}, > truncate = 50 > ) > form = SQLFORM.factory(Field('id', requires = IS_IN_SET(ids), > label = "Which event (number)?") > ) > if form.accepts(request.vars, session): > redirect(URL(r=request, f='show_fpipl01_data',vars=form_vars)) > else: > response.flash=repr(form.errors) > > return dict(data=data,tabel=tabel,form=form) > > Regards > Johann > > -- > May grace and peace be yours in abundance through the full knowledge of God > and of Jesus our Lord! His divine power has given us everything we need for > life and godliness through the full knowledge of the one who called us by > his own glory and excellence. > 2 Pet. 1:2b,3a