• Replies 3 replies
  • Subscribers 336 subscribers
  • Views 144 views
  • Users 0 members are here
Related

Custom field in Plans with a drop down

Jess Levy
$organization

Hi!

I am trying to build a custom field in Plans that will have a drop down and be available for use in lists/extractions. The custom element shows up, but there are no options in the drop down and I get a invalid entry message of "Ambiguous column name 'key_value'."

In T_Keyword, I have the following entries:

Data Type: String
Edit Mask: None
Detail Tbl: T_PLAN
Detail Col: !.custom_1
Ref Tbl: t_kwcoded_values
Ref Idcol: key_value
Ref Descol: key_value
Ref Where: keyword_no = 595
Ref Sort: key_value
Category: Plans
Use for List: Plan
Custom Id: 1

I then have the drop down options built in T_KWCODED_VALUES.

What am I missing?

Thanks
Jess Levy
San Francisco Opera
415-551-6319

Parents
  • $organization

    In this case you don't need to specify Ref Sort option in the T_Keyword table, as the same column is used for id as description the sort should be alphabetical anyway, if it isn't you can probably use 1 or 2 in the ref sort as this tells it to use column 1 or column 2 in the query for the sort ie specify by column order rather than column name..

    The Ref Sort option is normally used when your ID Column and Description Column are different so you can choose whether to order by the ID or the Description.

    Mark

Reply
  • $organization

    In this case you don't need to specify Ref Sort option in the T_Keyword table, as the same column is used for id as description the sort should be alphabetical anyway, if it isn't you can probably use 1 or 2 in the ref sort as this tells it to use column 1 or column 2 in the query for the sort ie specify by column order rather than column name..

    The Ref Sort option is normally used when your ID Column and Description Column are different so you can choose whether to order by the ID or the Description.

    Mark

Children
No Data