I will try both and i will let you know.
On Feb 22, 12:27 am, Richard Vézina <ml.richard.vez...@gmail.com> wrote: > On Tue, Feb 21, 2012 at 4:27 PM, Richard Vézina <ml.richard.vez...@gmail.com > > > > > > > > > wrote: > > Old > > > IS_IN_DB(helper_set,'table.id','%(field1)s (%(field2)s)',multiple=True) # > > One table > > > Maybe this work but not sure : > > > IS_IN_DB(helper_set,'table.id',db.table2(db.table1.id).fieldTable2,multiple > > =True) > > # 2 tables > > > Richard > > > On Tue, Feb 21, 2012 at 4:21 PM, Ashraf Mansour > > <ad...@aqar-riyadh.com>wrote: > > >> Thank you for the immediate reply. > > >> please rewrite the example using the old requires syntax. > > >> On Feb 21, 10:39 pm, Richard Vézina <ml.richard.vez...@gmail.com> > >> wrote: > >> > For represent I usually do : > > >> > lambda id: db.fktable1(id).represent_field # 1 table > >> > lambda id: db.fktable2(db.fktable1(id).id).represent_field_table2 # 2 > >> table > > >> > You can maybe proceding the same way, but I am not sure... I am still > >> using > >> > old requires syntax... > > >> > Please report your experiment and how you solve it. > > >> > Richard > > >> > On Tue, Feb 21, 2012 at 1:57 PM, Ashraf Mansour <ad...@aqar-riyadh.com > >> >wrote: > > >> > > Hi All, > > >> > > can the query in IS_IN_DB have more than one table? > > >> > > And how the fields of these tables be referenced in the format, to be > >> > > shown in the dropbox ? > > >> > > Thanks in advance. > > >> > > Ashraf
