[web2py] Re: one to many relationship but Foreign key as non-id,unique field.

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 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 wan

Re: [web2py] Re: one to many relationship but Foreign key as non-id,unique field.

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,

[web2py] Re: one to many relationship but Foreign key as non-id,unique field.

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-Tables On Aug 8, 8:00 am, Phyo Arka