I have two tables set up and i want to show the TimeCard with all the entries for said time card however im unsure of how to create such a view...
CONTOLLER: def timecard_index(): tcrows =db(db.timecard).select(orderby=~db.timecard.tc_date) tcinputs =db(db.timecard_entry).select(orderby=db.timecard_entry.timecard) return locals() MODEL: 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)) ) db.define_table('timecard_entry', Field('timecard', 'reference timecard', readable=False, writable=False,), Field('company', 'reference company', label='Company'), Field('tc_start', 'time', requires=[IS_TIME(),IS_NOT_EMPTY()], label='Start'), Field('tc_stop', 'time', requires=[IS_TIME(),IS_NOT_EMPTY()], label='Stop'), Field('st' , 'double', label='ST', default=0.0), Field('ot' , 'double', label='OT', default=0.0), Field('dt' , 'double', label='DT', default=0.0), Field('tc_classification' ,'string', label='Classification'), auth.signature) VIEW: {{for timecard in tcrows:}} <div class="well"> <table> <tr><td><strong>{{=A(timecard.employee.fname +' '+timecard.employee.lname,_href=URL('view_timecard',args=timecard.id))}} {{=timecard.tc_date.strftime("%m.%d.%Y")}}</strong></td></tr> {{for timecard_entry in tcinputs:}} <tr><td>{{=timecard_entry.company.name}}</td><td>{{=timecard_entry.tc_start}}</td><td>{{=timecard_entry.tc_stop}}</td><td>{{=timecard_entry.st}}</td><td>{{=timecard_entry.ot}}</td><td>{{=timecard_entry.dt}}</td><td>{{=timecard_entry.tc_classification}}</td></tr> {{pass}} </table> </div> {{pass}} This results in the same entries being put into each timecard (not the correct ones), I know I'm missing something in the logic but I'm too green of a programmer to see it... Im also not sure if im making the correct query for tcinputs... -- 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.