I have defined counter variable in controller.

I can define tables and fields dynamically.

tables = [db.define_table('example_table_%s' % x,Field('example_field_%s' % x, type='string', ...)...)for x in range(0, counter+1)]

I can add defined tables to SQLFORM.

form = SQLFORM.factory(db.table_1,db.table_2,*tables,submit_button='Submit')

I can control process manually if the counter value is '2'.

if form.process.accepted():id = db.table_1.insert(**db.table_1._filter_fields(form.vars))form.vars.table_1_field = idid = db.table_2.insert(**db.table_2._filter_fields(form.vars))#'0'form.vars.table_2_field = form.vars.example_field_0id = db.table_2.insert(**db.table_2._filter_fields(form.vars))#'1'form.vars.table_2_field = form.vars.example_field_1id = db.table_2.insert(**db.table_2._filter_fields(form.vars))#'2'form.vars.table_2_field = form.vars.example_field_2id = db.table_2.insert(**db.table_2._filter_fields(form.vars))

Above code works on my application.

How do I dynamically do the #'0', #'1' and #'2' steps?

for i in range(0, counter + 1):form.vars.table_2_field = form.vars['example_field_%s' % i]db.table_2.insert(**db.table_2._filter_fields(form.vars))

Also, if you are not using the dynamically generated tables to store data in the database, be sure to set migrate=False in the table definitions -- otherwise, the DAL will actually create each of those tables in the database.