I have two tables:
db.define_table('Account_Master',Field('Account',requires=IS_NOT_EMPTY()),Field('Sewadari1'),Field('Mb1'),Field('Sewadari2'),Field('Mb2'),Field('City'),Field('District'),Field('State'),Field('Email'),Field('Remark'),format='%(Account)s
%(State)s ')
db.define_table('Transaction_Master',Field('Account',db.Account_Master,requires=IS_IN_DB(db,'Account_Master.id',
'%(Account)s %(State)s',zero=T('choose
one'))),Field('Exam_Date','date'),Field('Entry_Date','date',default=request.now),Field('Form_1','upload'),Field('Form_1_Name'),Field('Schoolwise_Form','upload'),Field('Schoolwise_Form_Name'),format='%(Account)s
%(Exam_Date)s')
When i try to represent the account field of Transaction_Master table in
sqlform.factory as:
form=SQLFORM.factory(Field('TID',requires=IS_IN_DB(db,db.Transaction_Master.id,'%(Account)s
%(Exam_Date)s %(id)s')))
I am getting the id field of account in the sqlform.factory form. Is there
a way so that i may get the account name which that id field refers to in
the account master?
for example i am getting something like this in the selection scroll bar:
5 2012-05-08 1 where 5 is the Account_Master's id field. What if i want the
Account at id 5 to be shown in the sqlform.factory instead?
Also i think it neccessary to mention that I am using sqlform.factory
because i am seeking some parameters from users and i am storing those
parameters in session object to generate some report based on those.
