I have a table, called 'vehicles', and this has so many fields. In another, table, called 'photos', I have a field, called 'Vehicle', which is reference to my vehicle table ..
I'm doing a search form, and I need to filter records from my vehicle table, which have been referenced in the 'photos' table. Example, I'm using a query: innitial, the query starts 'query = db.veiculos.id> 0' .. And accordingly, the user fills the search form, I filter this query. For example: query & = db.veiculos.name == form.vars.name, In this search form, I have a field that is 'fotos: yes / no' .. If the user select 'yes', I want to go to my photos table, check which vehicles in the vehicles table, were referenced in any record in the photos table, ie, which vehicles have photos .. and filter this query in the same idea .. . Thanks a lot -- 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.
