Dropdown DW

[Neil]

Hi All, I have a problem with Dropdown DW. Example, this is
the list in the DDDW.
Code Description
1 ABC
2 ABC

I can't select the code 2, it will always return code 1,
even when I select the second line in the list which
supposedly should return the code 2.

What is the workaround on this?

Thanks,
Neil

[Neil]

I forgot to mention, I am using PB 10.2.1 Build 9948.

[Ivaylo Ivanov]

This is the default behavior of the DDDWs when you have a non-unique display
values.

Workaround - try to make the display values unique.
First option: add unique index upon your description column and push the
users to enter unique nomenclature texts
Second option: add a computed field with expression which makes it unique
and use this computed field as a Display Column of the DDDW instead of your
Description column (hide it in the dropdown):

descr_column + space(100) + fill("_", getrow())

or

descr_column + space(100) + fill("_", code_column)

This way, using space(...) makes the unique garbage part (underscore
character repeated unique number of times) to be displayed at the very right
of the cell, so if your dropdown width is set to 100%, the user won't see
this garbage at all.

Regards,
Ivaylo

<Neil> wrote in message news:4b29fa53.48d...@sybase.com...

[Ivaylo Ivanov]

Note that adding just unique number of spaces to the description won't do
the trick!

"Ivaylo Ivanov" <n0_S_p_a_...@isy-dc.com> wrote in message
news:4b2a1a49$1@forums-1-dub...