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
