[web2py] drop down values according to condition

[Neveen Adel]

Hello,

i have table

db.define_table("type",
      SQLField("name", "string"),
      SQLField("deleted", "boolean",default=False),
  )


and

db.define_table("ticket",
      SQLField("name", "string"),
      SQLField("type", db.type ),
  )

// here in ticket will display a drop down of types, i want that drop
down to have only  the un-deleted types (means deleted = false)

how can i do this?

Thanks