Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making surrogate keys, the Tastrade way
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00053840
Message ID:
00054098
Views:
32
>>Bret, VFP3 has problems handling numeric fields in Combo boxes. You may be using your IDs as the bound field in combos, particularly for lookup tables. Using Character fields avoids the problem, and it's easy to use a PadL() function to stuff leading zeroes into the character field.
>>
>>In VFP5, the combo problem was fixed.
>>
>>HTH
>>Barbara
>
>If my keys are not used as invoice numbers or something, why would I ever want my users to see them?

Bret, not for the users to see. In a lookup table, I often store the key field value, but want the user to see the description. In the combo, VALUE is the key field, DISPLAY VALUE is the description.

Hope this is clearer,
Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform