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

-- 



Reply via email to