I think it cover in as keyed table in the book Richard
On Thu, Nov 25, 2010 at 9:16 AM, Johann Spies <[email protected]>wrote: > I want to use a foreign key which does not refer to the id-field of another > record > > eg. > > > > db.define_table('journal', > Field('ouid','integer'), > Field('journal',unique=True), > Field('issn', length=10), > Field('notes', type='text'), > signature, > format=lambda r: r.journal > ) > > db.define_table('article', > Field('ouid', type='integer'), > Field('journal', type='string', length=255), > Field('journal_id', db.journal, requires = > IS_IN_DB(db,'journal.ouid')), > Field('volume', type='string', length=20)) > > I want 'journal_id' in 'article' to refer to 'ouid' in 'journal' and not > to 'id'. How do I do it in web2py. > > I am using postgresql as backend. I can define the foreign key in > Postgresql but how do I do it through DAL? > > Regards > Johann > > -- > May grace and peace be yours in abundance through the full knowledge of > God and of Jesus our Lord! His divine power has given us everything we need > for life and godliness through the full knowledge of the one who called us > by his own glory and excellence. > 2 Pet. 1:2b,3a > >
