i have a table member that include
and All_years table as the following:
db.define_table("All_years", SQLField("fromY","integer"), SQLField("toY","integer") )
and constrains are :
db.member.year.requires = IS_IN_DB(db, 'All_years.id','All_years.fromY')
The problem is when I select a year from dropdown the value of year column is the id of year, not the year value e.g: if year 2009 has db id=1 the value of year in db equal=1 not equal 2009.
I don't understand why.