pardon me, is your table definition is right?
e.g.
db.define_table('employee_login_detail',
Field('employee_code'),
Field('employee_email'),
Field('employee_name'),
Field('employee_login_date','date'),
Field('employee_login_time'),
Field('ip_address'))
db.define_table('employee_leave',
* Field('employee_code', 'reference employee_login_detail'),*
Field('email'),
Field('taken_vacation_leave','integer'),
Field('taken_medical_leave','integer'),
Field('taken_casual_leave','integer'),
Field('left_vacation_leave','integer'),
Field('left_medical_leave','integer'),
Field('left_casual_leave','integer'))just a suggestion, i think if you want to have the join table, you should have at least 1 fk field that reference to another table. after your table definition is all integrated, then you can start focus on the query logic. best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
