Here are my 2 tables defintion:
db.define_table('question',
Field('category_id',db.category),
Field('content'),
Field('number_of_options','integer'),
Field('has_options_detail','boolean',default=False)) ## Has or not
has detail for each option
db.define_table('options_detail', ## This table only for options that
have detail explanation
Field('question_id',db.question),
Field('serial'), ## Option ordering
Field('detail')) ## Detail explanation of option
How can I restrict that: db.options_detail.question_id must belong to
questions that have field "has_options_detail == True"?
Thanks in advance, folks!