Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using LOOKUP() for value of coded fields
Message
From
06/09/1996 20:32:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Using LOOKUP() for value of coded fields
Miscellaneous
Thread ID:
00007373
Message ID:
00007373
Views:
89
A table contains a field containing an abbreviation with the abbreviations and descriptions kept in a seperate abbreviations table how would one use the LOOKUP() to display the description rather than the abbreviation?

I've tried the following code in the textbox refresh event, but there seems to be a delay as I scroll thru the records.

LOCAL lcAbbrev
lcAbbrev = TRIM(THIS.value)
IF !USED("abbrev")
USE abbrev IN 0
ENDIF
SELECT abbrev
lcAbbrev = LOOKUP(descript, 'COLOR ' + lcAbbrev, abbrev, 'TYPE')
IF !EMPTY(lcAbbrev)
THIS.value = lcAbbrev
ENDIF


Kim
Next
Reply
Map
View

Click here to load this message in the networking platform