I will check out your suggestions, however for now i have solved like this
SOLVED WITH THIS:
db.define_table('timecard',
Field('tc_date','date'),
Field('employee', 'reference
employee',requires=IS_IN_DB(db,'employee.id','%(fname)s %(lname)s')),
Field('myid', unique=True, compute=lambda r: str(r.tc_date)
+ str(r.employee))
)
#validate that only one timecard is created per employee per day
db.timecard.tc_date.requires =
IS_NOT_IN_DB(db(db.timecard.myid==str(request.vars.tc_date)+str(request.vars.employee)),
'timecard.tc_date')
db.timecard.employee.requires.append
=IS_NOT_IN_DB(db(db.timecard.myid==str(request.vars.tc_date)+str(request.vars.employee)),
'timecard.employee')
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
