[web2py] problem with custom primarykey

[Andrew]

See the dot point 
Keyed table can only refer are to other keyed tables.
You have a mixture of Id fields and keys.