Anthony, the basic recommendation was to use SQLFORM.factory, and that was
a good idea. I tried it again and i had now more success than some weeks
before. So now i can insert rows in the table "book" and the table "verb"
in one FORM and with only one submit-button. The FORM looks like this:
form=SQLFORM.factory(db.book, db.verb.anr)
if form.process().accepted:
id = db.book.insert(**db.book._filter_fields(form.vars))
db.commit()
booknumber = id
authornumber = form.vars.anr
id = db.verb.insert(bnr=booknumber,anr=authornumber)
db.commit()
response.flash='Bingo!'
It looks very good but you know, if you have succesfully finished a job,
you find some other problems...
