The database view trick would work. Or how about adding a "current" flag and whenever you do a situation update/insert you set the new record's current flag to true and those of all that person's other situation records to false. You could either do it in web2py or with a database trigger. Seems to me it would be best to explicitly mark which one is the correct status rather than having to infer it based on an id number.
Did you look at web2py's record versioning which might just take care of this for you automagically? -- 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.
