I'm certainly no expert but I might try to define:
ref_asset_category.format=('%(asset_category_name)s') or something like
that.
Check my syntax of course. Hope it works.
-Bill
On Saturday, October 13, 2012 7:11:35 PM UTC-5, Kenneth wrote:
>
> Hello,
>
> this is my first time trying to connect to a legacy database. My
> database models file looks like this:
>
> db.define_table('ref_asset_category',
> Field('asset_category_id', type='id'),
> Field('asset_category_name', type='string'))
>
> ########################################
> db.define_table('assets',
> Field('asset_id', type='id'),
> Field('asset_label', type='string'),
> Field('asset_category_id', 'reference ref_asset_category'))
>
> When using crud to edit a assets record the asset_catefory_id is only
> shown as an text box, not as an drop down selection box.
>
> What am I doing wrong?
>
>
> Kenneth
>
>
--
