Lookup Button - 'Display Description instead of Value' Problem

[johanco123]

Hi Bruce

Using Nt9.19. I have a string field on a netwebform with a lookup button.. On the Lookup Settings TAB in the 'Value field' i have UniqueID value and in the 'Description field' the Name description value.

If 'Display Description instead of value' is tick OFF - the  UniqueID display in the field and save the  UniqueID in the table. That is correct.
BUT
If 'Display Description instead of value' is tick ON - the Description display in the field and save the  Description value now  in the table. How can i correct this because it must still save the  UniqueID as the value in the field and not the description.

Regards
Johan

[terryd]

Hi Johan
Does your description field have a unique key? It will need one for the lookup to work correctly.

[Bruce]

>> Using NT9.19.

9.26 is out.

>> If 'Display Description instead of value' is tick ON - the Description display in the field and save the  Description value now  in the table. How can i correct this because it must still save the  UniqueID as the value in the field and not the description.

make sure you have a single-component key on the description field. Ideally this field should be unique (if it's not unique then _any_ code matching that description may be saved.)

Cheers
Bruce