i have the follwing tables:
db.define_table('topmenu',
Field('parent',type='integer', requires=IS_EMPTY_OR(IS_IN_DB(db,
'topmenu.id', '%(title)s'))),
Field('link', type='string', label=T('Link')),
Field('title', type='string',label=T('Title Ro')),
Field('content', type='text',label=T('Content En')),
Field('added_on', 'date', default=request.now,
requires=IS_DATE(format=T('%d-%m-%Y')), writable=False),
Field('updated_on', 'datetime', default=request.now,
update=request.now, requires=IS_DATETIME(format=T('%d-%m-%Y %H:%M:%S')),
writable=False),
Field('public', 'boolean', default=True)
db.define_table('sidemenu',
Field('parent',type='integer', requires=IS_EMPTY_OR(IS_IN_DB(db,
'sidemenu.id', '%(title)s'))),
Field('link', type='string', label=T('Link')),
Field('title', type='string',label=T('Title')),
Field('content', type='text',label=T('Content')),
Field('added_on', 'date', default=request.now,
requires=IS_DATE(format=T('%d-%m-%Y')), writable=False),
Field('updated_on', 'datetime', default=request.now,
update=request.now, requires=IS_DATETIME(format=T('%d-%m-%Y %H:%M:%S')),
writable=False),
Field('public', 'boolean', default=True)
how to reference table below with this 2 tables,
db.define_table("articles",
Field('reference', db.sidemenu, requires=IS_IN_DB(db, 'sidemenu.id',
'%(title)s')), *# here i need smth like : db.sidemenu | db.topmenu ... and
is_in_db(db,'sidemenu.id' or 'topmenu.id')*
Field('image', 'upload'),
Field("title",label=T('Title Ro'),requires=IS_NOT_EMPTY()),
Field("content" ,type='text',label=T('Content
Ro'),requires=IS_NOT_EMPTY()),
Field('added_on', 'date', default=request.now,
requires=IS_DATE(format=T('%d-%m-%Y')), writable=False),
Field('updated_on', 'datetime', default=request.now,
update=request.now, requires=IS_DATETIME(format=T('%d-%m-%Y %H:%M:%S')),
writable=False),
Field('event', 'boolean', default=False),
Field('public', 'boolean', default=True))
