Cross reference between tables, see this post http://groups.google.com/group/web2py/browse_thread/thread/b3cb1ce223649e0f/14688d53b3d88857?lnk=gst&q=table+cross+reference#14688d53b3d88857
On Nov 11, 12:44 am, Mirek Zvolský <[email protected]> wrote: > I have simplest model: > > db.define_table('company', > Field('name'), > Field('created_by', 'reference person')) > db.define_table('person', > Field('last_name'), > Field('company_id', 'reference company')) > > but I receive error: > File "C:\Python27\Lib\site-packages\web2py\gluon\sql.py", line 1643, > in _create_references > raise SyntaxError, 'Table: table "%s" does not exist' % referenced > > So it looks not like a bug, but as behaviour by design (raise > SyntaxError). > > What I do wrong? > I simple need a standard possibilities of relations/joins, because I > want design database application, not static html pages :-(( > > Thanks for help. Mirek
