>For example, in a gl account table, I want the user to be able to select between several types for the account, such as Asset, Liability, etc... But in my table, I just want to save "A" or "L" for example. Is there a way to set it so it is not the description on the screen that would be saved, but an alternative value?
>
>Thanks
>Eric
Unbind the optiongroup (Controlsorce- None) and fill the field programmatically:
DO CASE
CASE thisform.optiongroup.value=1
cFillValue="A"
CASE thisform.optiongroup.value=2
cFillValue="C"
***etc.
ENDCASE
Replace mytable.myfield with cFillvalue
Edward Pikman
Independent Consultant