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.
