Massimo Where would this code go, in the model after the table definition:
db.define_table('timetable', Field('company',db.company), Field('activity'), Field('day',db.day), Field('time',type='time'), Field('duration'), Field('level',db.level), migrate=False) myactivities = db((db.company_activity.bedrijf==auth.user.bedrijf)& (db.company_activity.activity==db.activity.id)) .select(db.activity.activity) db.timetable.activity.requires=IS_IN_SET([row.activity for row in myactivities]) ... or in a function in a controller. @auth.requires_membership('site_manager') def create_timetable(): response.view='default/form.html' response.flash='Insert les' db.timetable.company.default=auth.user.company myactivities = db((db.company_activity.bedrijf==auth.user.bedrijf) & (db.company_activity.activity==db.activity.id)).select (db.activity.activity) db.timetable.activity.requires=IS_IN_SET([row.activity for row in myactivities]) form=create_form(db.timetable,message='Class inserted') return dict(form=form) Which of the two options would you go for? Kind regards, Annet -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.