No dice. I think I'm going to take your original advice and build a
reference table, though. Thanks again for your help.
On Fri, Mar 30, 2012 at 9:13 PM, Derek <sp1d...@gmail.com> wrote:
> I see what you mean. In that case, you don't want to reference the other
> table, since you don't have a many to many table.
> For many to many relationships, you should have three tables.
>
> table_one
> table_two
> table_relationship_between_one_and_two
>
> But if you just want a list of the strings like so: '%(first)s -
> %(second)s Against %(third)s'
> What you wrote should work, based on what it says in the documentation,
> the defaults should be sufficient. You can try this -- add:
>
> db.table_two.requires=IS_IN_DB(db,table_one.id, db.table_one._format,
> multiple=True)
>
> That's just explicitly defining what should be the default...
>
> On Friday, March 30, 2012 1:49:12 PM UTC-7, pjryan126 wrote:
>>
>> 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!
>>>
>>
