Ok, forget notice, I think, I just should use something like this :
db.table2.linked_self.requires=\
IS_EMPTY_OR(IS_IN_DB(db,'table2.id','%(field1t2)s',\
orderby=('field1t2'),multiple=True))
But, still the list representation not working in crud.select for self
referenced field.
Richard
On Wed, Aug 17, 2011 at 4:29 PM, Richard Vézina <[email protected]
> wrote:
> Here a simple app that show the problem, I made on the same table a self
> referenced field and a foreign referenced field...
>
> I notice, also, that the "nav built-in wigdet" for multiple don't works
> neither in the crud.update or create form...
>
> Thanks
>
> Richard
>
>
> On Wed, Aug 17, 2011 at 4:09 PM, Richard <[email protected]>wrote:
>
>> Hello,
>>
>> I think I have a issue with list:reference with a self referenced
>> table the representation not working in sqltable... It's work when I
>> change my referenced table from the self referenced to a different
>> table...
>>
>> Book says :
>> While list:reference has a default validator and a default
>> representation...
>>
>> web2py 1.98.2
>>
>> Thanks
>>
>> Richard
>
>
>