hi,
is anybody know how to create nested list? my intention is to create
category that have sub category (parent child list), should i use 2
table or just one table that refer to itself?
e.g.
db.define_table('category',
Field('title'
)
)
db.define_table('sub_category',
Field('title',
label = T('Title')
),
Field('category_id',
db.category
)
)
db.sub_category.category_id.requires = IS_IN_DB(db, db.category.id, '%
(title)s')
or
db.define_table('category',
Field('title',
label = T('Title')
),
Field('parent_category_id',
'reference category'
),
)
db.category.parent_category_id.requires = IS_IN_DB(db, db.category.id,
'%(title)s')
and how about the controller and the views to display it?
please give an advice, pointer or suggestion.
thank you very much in advance