my model for users_group
db.define_table('users_group',
Field('name'),
Field('description','text',default='No group description'),
Field('owner',db.auth_user),
Field('company',db.auth_user),
Field('open','boolean',default=False),
Field('created_on','datetime',default=timestamp))
db.users_group.company.requires=IS_IN_DB(db,'auth_user.id','%(company_name)s')
db.users_group.name.requires=IS_NOT_EMPTY()
db.users_group.owner.requires=IS_IN_DB(db,'auth_user.id','%(name)s')
db.users_group.access_types=['no','view','join']
db.users_group.public_fields=['company','name','description','open']
