NetTalk Central

Author Topic: Lookup Button - 'Display Description instead of Value' Problem  (Read 3850 times)

johanco123

  • Full Member
  • ***
  • Posts: 245
    • View Profile
    • Email
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

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: Lookup Button - 'Display Description instead of Value' Problem
« Reply #1 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.
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: Lookup Button - 'Display Description instead of Value' Problem
« Reply #2 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