Right, but web2py has auto-named the primary key "id" in both tables Person
and Skill.
If I rename the "id" field Person_id in PersonSkill table, it won't be
copied/referenced correctly from table Person.
Is the only way to handle this by renaming the Person table field from "id"
to "Person_id"?
thanks!
Alex
On Tuesday, January 1, 2013 2:54:49 PM UTC-8, rochacbruno wrote:
>
> You can't have duplicated field names
>
> db.define_table('PersonSkill',
>> Field('*Person_id*','reference Person'),
>> Field('*Skill_id*','reference Skill'),
>> Field('YearsOfExperience','integer'))
>>
>
>
--
