Something like this in the controller: eventtyperows=db(db.event.eventtype==db.eventtype.id).\ select(db.event.eventtype,db.eventtype.eventtype,\ distinct=True,orderby=db.eventtype.eventtype)
a=[e.event.eventtype for e in eventtyperows] b=[e.eventtype.eventtype for e in eventtyperows] form=SQLFORM.factory(SQLField('eventtype',requires=IS_IN_SET(a,b)) Annet.