Derek:
Thanks for your response. It's a many-to-many relationship between
table_one and table_two. i was hoping to denormalize this relationship with
list:reference, but maybe it's more trouble than it's worth in this case.
On Friday, March 30, 2012 3:38:23 PM UTC-4, pjryan126 wrote:
>
> I have the following two tables:
>
> db.define_table('table_one',
> Field('first', db.first, '%(name)s'),
> Field('second', db.second, '%(name)s'),
> Field('third', db.third, '%(name)s'),
> format = '%(first)s - %(second)s Against %(third)s')
>
> db.define_table('table_two',
> Field('fourth', db.fourth),
> Field('fifth', db.fifth),
> Field('table_ones', 'list:reference table_one'),
> Field('sixth', list:string)
>
> When I go to add a record to the db.form table in appadmin, the
> db.form.plan_classes drop-down box populates using the id's in the
> respective db.table_one fields (i.e., "1 - 1 Against 2", etc).
>
> How would I get the items in the db.table_two.table_ones list to appear in
> a drop-down box using the field representations assigned in the
> db.table_one table definition? Any help on this would be greatly
> appreciated!
>
