Thanks for the answers.
This representation works perfectly when i show the content in a dropdown
so i think this has more to do with SQLFORM.grid...
2012/7/9 Anthony <abasta...@gmail.com>
> db.define_table('clients',
> Field('number'),
>
> Field('name'),
> format='%(name)s')
>
> Then you don't have to explicitly define the IS_IN_DB validator, as
> sessions.client_id will get one by default with the format set to the
> db.clients format attribute. In that case, the sessions.client_id represent
> attribute will also be set to the db.clients format attribute.
>
> Anthony
>
>
> On Monday, July 9, 2012 8:35:41 AM UTC-4, Remco K wrote:
>>
>> Hi everyone,
>>
>> I'm working with SQLFORM.grid but I cant get the referenced table
>> representation to work. The only thing i get is the ID of the referenced
>> table(s):
>>
>> *db.py: *
>> db.define_table('clients',
>> Field('number'),
>> Field('name')
>> )
>>
>> db.define_table('sessions',
>> Field('client_id', db.clients),
>> Field('state')
>> )
>>
>> db.sessions.client_id.requires = IS_IN_DB(db, db.clients, '%(name)s')
>>
>> *controller:*
>> fields = (db.sessions.client_id)
>> headers = {'sessions.client_id':"Client"**}
>>
>> _form = SQLFORM.grid(db.sessions.id>0 ,fields=fields,
>> headers=headers,maxtextlength
>> =500)
>> *
>> I get:*
>> Client
>> 111
>>
>> *Instead of:*
>> Client
>> <client.name>
>>
>> I've Googled for a while but i cant find any solution yet.
>>
>> The version of Web2Py i'm using:
>>
>> Version 2.0.0 (2012-06-29 20:55:40) dev
>>
>> Thanks in advance!Remco
>>
>
--
Met vriendelijke groet,
Remco Klappe
