I've an associate table for many-to-many relationship with composite
key defined as follows :
db.define_table('user_skill',
Field('user', db.user),
Field('skill', db.skill),
primarykey=['user', 'skill'])
When I use SQLFORM.grid for the above table, I get the following error :
File "/home/mandar/web2py/gluon/sqlhtml.py", line 1596, in grid
field_id = tables[0]._id
File "/home/mandar/web2py/gluon/dal.py", line 7357, in __getattr__
return self[key]
File "/home/mandar/web2py/gluon/dal.py", line 7297, in __getitem__
return dict.__getitem__(self, str(key))
KeyError: '_id'
SQLFORM.grid seems to be looking explicitly for 'id' field hence the error.
Is there a workaround ?
Thanks,
-Mandar
--