Foreign keys in web2py database

Question

I use web2py framework with two tables. How can I refer one field from first table into second table?

Answer 1

Here's the section on table relationships and JOINs from the web2py chapter on databases

To illustrate how to implement one to many relations with the web2py DAL, define another table "dog" that refers to the table "person" which we redefine here:

>>> db.define_table('person',
                    Field('name'),
                    format='%(name)s')
>>> db.define_table('dog',
                    Field('name'),
                    Field('owner', db.person),
                    format='%(name)s')

You'll need to provide more information if you are looking for something that's not covered in that reference.

Answer 2

See The Database Abstraction Layer chapter of the book, in particular, the section on One to Many Relations. If you're working with a pre-existing/legacy database, see Legacy Databases and Keyed Tables. Also, here's an example.