Given that you are pretty down the line of deciding what table needs to be
"touched", you should just write a wrapper that either inserts a record on
work_table and let the users edit it or that it copies the values from the
ro_table to the work_table as defaults, and then prepare a "prefilled" form
with fields from the work_table.
pseudo_code
if user_selected_ro:
values = db(db.ro_table.id == user_selected_ro).select().first()
.....
for f in db.work_table.fields:
db.work_table[f].default = values[f]
form = SQLFORM(db.work_table)
.....
Given that some of the fields are calculated, you may want to use
SQLFORM.factory as well, because you'd likely want to manage the inserted
data a little bit before the insertion on the work_table.
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.