If the 'student' and 'contact' fields should each, individually, refer
to a record in the auth_user table then I'd use:
Field('student', 'reference auth_user'),
Field('contact', 'reference auth_user'),
...at least that is what I'd try first...
-Jim
On 8/8/2011 2:58 PM, Richard Vézina wrote:
If you send you controller and model code at least with trace back it
could help to troobleshoot...
Richard
On Mon, Aug 8, 2011 at 3:51 PM, Eric Scott <erictransla...@gmail.com
<mailto:erictransla...@gmail.com>> wrote:
I'm having problems getting tables linked in web2py using reference
fields. For example, I have a model with table student and table
contact. Table auth_user contains my app's users. In db.py, under
db.define_table('auth_user') I have the following code to reference a
one-to-many relationship between users:students and users:contacts:
Field('student', db.student),
Field('contact', db.contact),
But I keep getting the following error:
Traceback (most recent call last):
File "/home/www-data/web2py/gluon/restricted.py", line 192, in
restricted
exec ccode in environment
File "/home/www-data/web2py/applications/teachertext/models/db.py",
line 61, in <module>
Field('student', db.student,
File "/home/www-data/web2py/gluon/dal.py", line 4331, in __getattr__
return self[key]
File "/home/www-data/web2py/gluon/dal.py", line 4325, in __getitem__
return dict.__getitem__(self, str(key))
KeyError: 'student'
I'm new to web2py (but not to frameworks) and this is my first time
referencing foreign keys in a web2py app. I'm sure I'm missing
something obvious but I'd be grateful if someone could point it out
for me.
Thank you,
Eric
