Jim, Sorry to bother you again but still can't get this working. I need to join my 2 tables by a date and not the DB ID key. Not sure if this can be done since it looks like Web2Py looks to join by DB ID only. In SQL this would be a simple join by date after building a date index on the date field in both tables.
Thanks Again On Friday, February 15, 2013 10:29:46 PM UTC-6, Dan Kozlowski wrote: > > Does anyone know if I smartgrid to can create another button next to > View, Edit, Delete that will allow it to open a new search screen ? I have > a customer ( 1 to many notes) and would like a Notes button that takes > you to another search screen to allow you to view 1 to many Notes a > customer can have ? -- --- 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.