Hello. Calling a field from a referenced field is not possible. Ticket is 'Field' object has no attribute 'event_datetime'.
Model: db.define_table('events', Field('title', type='string'), Field('event_datetime', type='datetime'), auth.signature) db.define_table('events_users', Field('going_event', 'reference events'), auth.signature) Controller: going_events = db((db.events_users.created_by == auth.user.id) & (db. events_users.going_event.event_datetime >= datetime.datetime.today())). select() How can I make this query? Thanks for the help. -- 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/d/optout.