I have defined three tables db.define_table('category_cat', Field('userinfo',db.auth_user,default=auth.user_id, writable=False,readable=False), Field('name', requires=IS_NOT_EMPTY()))
db.define_table('category', Field('userinfo',db.auth_user,default=auth.user_id, writable=False,readable=False), Field('category_cat',db.category_cat,requires=IS_IN_DB(db, db.category_cat.id,'%(name)s')), Field('name', label='Sub Category', requires=IS_NOT_EMPTY()), Field('description', 'text')) db.define_table('listing', Field('userinfo',db.auth_user,default=auth.user_id, writable=False,readable=False), Field('category', db.category, label='Category * ~can select multiple~', requires=IS_IN_DB(db,db.category.id,'%(name)s',multiple=True)), I would like to display the category_cat entries in the Multi Select Form Field (for the listings table) make them unselectable and group the category entries under each one is this even possible? If so how can I achieve this result So for example in the Multi Select Form (listing table) I would like to have category_cat 1 (not selectable) category 1 category 2 category_cat 2 (not selectable) category 3 category 4 but displaying the name value :-) I hope I made sense and some one can help me :-) Thank you --