ok, what if i have a nested type select field like:
db.define_table('class_assignments',
Field('class_id', db.classes, requires=IS_IN_DB(db, db.classes.id,
'%(class_title)s (%(id)s)'), writable=False, readable=False),
Field('lecture_id', db.lectures,
requires=IS_IN_DB(db(db.lectures.user_id == auth.user_id), db.lectures.id,
'%(title)s (%(id)s)')),
Field('lecture_item_id', db.lecture_items, requires=IS_IN_DB(db,
db.lecture_items.id, '%(title)s (%(id)s)')),
...
where in this case i want the user to select the lecture_id first, and then
the lecture_item_id would be a subset or a detail list of the master
lecture_id. i tried:
Field('lecture_item_id', db.lecture_items,
requires=IS_IN_DB(db(db.lecture_items.lecture_id == lecture_id),
db.lecture_items.id, '%(title)s (%(id)s)')),
and:
Field('lecture_item_id', db.lecture_items,
requires=IS_IN_DB(db(db.lecture_items.lecture_id ==
db.class_assignments.lecture_id), db.lecture_items.id, '%(title)s
(%(id)s)')),
but both attempts failed. so how do i do a subselect kind of model? thanx
in advance, lucas
--
