Here is an example from: http://web2py.com/books/default/chapter/29/07
db.define_table('person', Field('name', unique=True)) db.define_table('dog', Field('name'), Field('owner', db.person) db.dog.owner.requires = IS_IN_DB(db, 'person.id', '%(name)s', zero=T('choose one')) Can someone please write out the syntax for displaying all of the joined data using the most up-to-date way (SQLForm, or whatever. I believe CRUD can't do more than one table)? Kindly include any code needed to display the data in a view. Can you also show me the code to allow users to select a record and edit one of the tables? Please also include code needed to make the options visible to user in a view. Thanks, Alex Glaros --