Thanks Anthony, I want to explicitly link the tables as you described above. Do I put this code in in the DB_WIZARD.PY file? If so how would I modify it. Everything I try produces an error on save. Here are the two tables in question.
db.define_table('t_ab_distribution', Field('f_distributionname', type='string', unique=True, label=T('Distributionname')), Field('f_location1', type='string', label=T('Location1')), Field('f_location2', type='string', label=T('Location2')), Field('f_location3', type='string', label=T('Location3')), Field('f_location4', type='string', label=T('Location4')), Field('f_distributiondate', type='date', label=T('Distributiondate')), Field('f_contact1', type='string', label=T('Contact1')), Field('f_phone1', type='string', label=T('Phone1')), Field('f_contact2', type='string', label=T('Contact2')), Field('f_phone2', type='string', label=T('Phone2')), Field('f_contact3', type='string', label=T('Contact3')), Field('f_phone3', type='string', label=T('Phone3')), Field('f_contact4', type='string', label=T('Contact4')), Field('f_phone4', type='string', label=T('Phone4')), auth.signature, format='%(f_distributionname)s', migrate=settings.migrate) db.define_table('t_ab_distribution_archive',db.t_ab_distribution,Field('current_record','reference t_ab_distribution',readable=False,writable=False)) ############################### db.define_table('t_ab_recipient', Field('f_recipient_name', type='string', label=T('Recipient Name')), Field('f_recipient_phone', type='string', label=T('Recipient Phone')), Field('f_recipient_number', type='string', label=T('Recipient Number')), Field('f_team_num', type='string', label=T('Team Num')), Field('f_gps_coord', type='string', label=T('Gps Coord')), Field('f_recipients_photo', type='upload', label=T('Recipients Photo')), Field('f_distribution_name', type='string', label=T('Distribution Name')), Field('f_location_spesific', type='string', label=T('Location Spesific')), auth.signature, format='%(f_recipient_name)s', migrate=settings.migrate) db.define_table('t_ab_recipient_archive',db.t_ab_recipient,Field('current_record','reference t_ab_recipient',readable=False,writable=False)) On Nov 19, 11:42 am, Anthony <abasta...@gmail.com> wrote: > You could do: > > db.t_ab_recipient.f_distribution_name.requires = IS_IN_DB(db, > 't_ab_distribution.f_distributionname') > > Seehttp://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.