Yes, that is true,you'd have to join by the primary ID field of the other table. But, looking at your table, couldn't you use the ID instead of the date? I guess I'm a bit anal about the way I like tables, I always use the ID fields.
On Tue, Feb 19, 2013 at 9:30 PM, Dan Kozlowski <bwdr...@gmail.com> wrote: > 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. > > > -- --- 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.
