Well I may have spoke too soon...

I have another table...this one:

db.define_table('t_ab_team',
    [snip]
    Field('f_distribuionname', type='string',
          label=T('Distribuionname')),

And I want to link the above field so that it show a drop down list
also using the contents of the following field

db.define_table('t_ab_distribution',
    Field('f_distributionname', type='string', unique=True,
          label=T('Distributionname')),

So I tried this as I had before with the other drop down list that I
wanted:

    Field('f_distribuionname', db.t_ab_distribution,
          label=T('Distribuionname')),

Now I have broken something.  Is this because I cannot explicitly link
both

db.t_ab_recipient.f_distribution_name  ###would like this to show a
drop down list
db.t_ab_team.f_distribuionname         ###would like this to show a
drop down list

to

db.t_ab_distribution.f_distributionname ###contents of drop downlist

or am I doing something else wrong?



On Nov 20, 6:47 am, EdgarAllenPoe <tomstouts...@gmail.com> wrote:
> Thanks again Anthony,
>
> Your help has been clear and concise.  I have what I need now.
>
> About the error thing.  Just to be clear where I am working from.  I
> am using the online editor 
> at:http://127.0.0.1:8000/admin/default/edit/XxxxxxXxxx/models/db_wizard.py
>
> And for a test I just removed one of the commas at the end of a line
> and tried to save the file, which produced this error in an orange pop
> up message:
>
> failed to compile file because:
> SyntaxError at line 50 at char 8
> invalid syntax (C:/web2py/applications/XxxxxxXxxx/models/db_wizard.py,
> line 50)
>
> So I guess it is saving the file, but failing to compile.  Would that
> be a better way to state what is happening?
>
> Thanks again.
>
> On Nov 19, 6:14 pm, Anthony <abasta...@gmail.com> wrote:
>
>
>
>
>
>
>
> > > db.define_table('t_ab_recipient',
> > >     [snip]
>
> > change:
>
> > >     Field('f_distribution_name', type='string',
> > >           label=T('Distribution Name')),
>
> > to:
> >         Field('f_distribution', db.t_ab_distribution,
> >             label=T('Distribution Name')),
>
> > Note, your code wouldn't be producing any errors on save (saving just saves
> > the file -- it doesn't run or even check any of the code). If you're
> > getting errors when merely trying to save the updated file, there's
> > something else wrong (I'm not sure what).
>
> > Anthony

Reply via email to