NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: johanco123 on April 21, 2017, 01:14:49 AM

Title: Lookup Button - 'Display Description instead of Value' Problem
Post by: johanco123 on April 21, 2017, 01:14:49 AM

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

Title: Re: Lookup Button - 'Display Description instead of Value' Problem
Post by: terryd on April 21, 2017, 03:21:27 AM

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

Title: Re: Lookup Button - 'Display Description instead of Value' Problem
Post by: Bruce on April 23, 2017, 10:35:36 PM

>> 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