you should allow to use "normal m2o" relations. i mean with another table in db. i know it doesn't work on GAE but users should have choice.
On 30 Maj, 08:21, annet.verm...@gmail.com wrote: > Massimo, > > Will it be possible to have a foreign key on a non id field, in case > of a look-up table? > > In my model I have: > > db.define_table('rechtsvorm', > SQLField('rechtsvorm',label='Rechtsvorm * > ',length=42,default='',notnull=True,unique=True), > migrate=False) > > db.define_table('bedrijf', > SQLField(..), > SQLField('rechtsvorm',length=42,default='Onbekend'), > SQLField(..), > migrate=False) > > db.bedrijf.rechtsvorm.requires=IS_IN_DB(db,db.rechtsvorm.rechtsvorm,'% > (rechtsvorm)s') > > It would be nice to have db.rechtsvorm.rechtsvorm directly in the > field definition and have the DAL create a foreign key constraint. > > Will the new DAL also solve the problem described in this thread: > > http://groups.google.com/group/web2py/browse_thread/thread/fb79182029... > > Kind regards, > > Annet. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---