Foreign keys in web2py database

Question

I am using web2py framework with two tables. How can I assign one field from the first table to the second table?

Answer 1

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

To illustrate how to implement one to many relationships with web2py DAL, define another table called “dog” that refers to the table “person”, which we will 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 will need to provide additional information if you are looking for something that is not described in this link.

Answer 2

. , , . / , . . , example.