I would use the autocomplete widget. If you really want a text input and a combo box I would probably do a custom widget. Here's a full example using the autocomplete widget, this solution uses the welcome app with this added to db.py before auth.define_tables(username=False, signature=False)
db.define_table('organization', Field('name', requires=IS_NOT_EMPTY()) ) auth.settings.extra_fields['auth_user'] = [ Field('organization', 'reference organization', widget=SQLFORM.widgets. autocomplete(request, db.organization.name, id_field=db.organization.id)) ] def add_organization(form): """ Adds an organization if it doesn't exist, validates all fields. """ if not form.vars.organization: ret = db.organization.validate_and_insert(name=form.vars. _autocomplete_organization_name_aux) if ret.errors: form.errors.organization = ret.errors['name'] else: form.vars.organization = ret.id else: output, error = IS_IN_DB(db, db.organization.id)(form.vars. organization) if error is not None: form.errors.organization = error auth.settings.register_onvalidation = add_organization -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.