No. But you can enforce the reference at the web2py level with the IS_IN_DB validator.
On Aug 8, 2:36 am, Phyo Arkar <phyo.arkarl...@gmail.com> wrote: > Yes i understand that 1 to Many do not link to Field but Record but i need > to Reference to a Field which is not id . > so with that i can set two primary keys but i want to reference to EmailID > (which is not auto increment Integer but a md5sum , string , Unique) . > > Is that possible? > > On Sun, Aug 8, 2010 at 1:36 PM, qqsaqq <sla...@gmx.net> wrote: > > as I understand this, the DAL always uses the id field for referencing > > in a one to many relationship. And: you don't link to a certain field > > (EmailID) but to a record of your emails table. > > > see > >http://web2py.com/book/default/chapter/06#Legacy-Databases-and-Keyed-... > > > On Aug 8, 8:00 am, Phyo Arkar <phyo.arkarl...@gmail.com> wrote: > > > I am Thinking to link two tables , > > > "emails" and "attachments" > > > > emails have a unique key , EmailID , which is a md5sum of the path to > > email > > > file > > > > I am trying to link with another table which is attachment table , it > > will > > > have a field 'attachment_of' which is link to "EmailID" > > > > To Short > > > > How can i link between primary and foreign keys which is a > > > non-id_but_unique field?