You could do: db.t_ab_recipient.f_distribution_name.requires = IS_IN_DB(db, 't_ab_distribution.f_distributionname')
See http://web2py.com/book/default/chapter/07#Database-Validators. Instead, though, you might want to explicitly link the two tables: db.define_table('t_ab_distribution', Field('f_distributionname'), format='%(f_distributionname)') db.define_table('t_ab_recipient', Field('f_distribution', db.t_ab_distribution)) That will automatically add an IS_IN_DB validator to f_distribution, and it will display the f_distributionname in the list due to the format='%(f_distributionname)'. Anthony On Saturday, November 19, 2011 9:05:21 AM UTC-5, EdgarAllenPoe wrote: > > Can some one show me what the code would look like to accomplish the > following: > > Create a drop down list for field A > that will be populated by field B > > A. db.t_ab_recipient.f_distribution_name > > B. db.t_ab_distribution.f_distributionname > > Any help would be appreciated. > >