COMBOBOX with 2 element array

[TimStone]

I thought this was addressed earlier with a simple solution. I can write code to "make it happen" but if it is already addressed with FWH, I would like to use it:

Field 1 is a title
Field 2 is a description.
Both are in a database
I want to read them into a 2 element array.
Then, using a combobox ( or listbox ), I want the first element ( field 1 ) to be the items
When an item is selected ( ON CHANGE ), I want the value in the second element to be assigned to a variable used in a separate GET ( for editing ).

I thought this was addressed in the forum, and code, previously, but I can't find it.

Currently I assign the values to 2 arrays, use the first to select the title, and knowing it's position, I load the corresponding value from the second array into the variable. That has been my procedure in the past but I "think" a more direct approach was shared previously.

Any thoughts will be helpful. Thanks.

[Antonio Linares]

Dear Tim,

Here you have what we recently did:
viewtopic.php?p=252389&sid=daf03f16b17c5b26d15d18e6316a6c28#p252389

[nageswaragunupudi]

Mr. Tim
That is what DBCOMBO is supposed to do
Please look for samples of DBCOMBO

[TimStone]

I looked at the other posts, and also studied dbcombo. Those were really more complex then I need.

Code: Select all  Expand view

   REDEFINE COMBOBOX oCbxA1 VAR cScript  ID 106 OF oeText ;
      ITEMS aSMScode  ON CHANGE ( lx := oCbxA1:nAt, cBody := aSMStext[lx], oGet1:refresh() )   ;
      MESSAGE "Select a script" STYLE CBS_DROPDOWN UPDATE
   
    REDEFINE GET oGet1 VAR cBody MEMO  ID 103 OF oeText MESSAGE "Enter the text of your message" UPDATE
 

I took the DBF, and put the first field in the array aSMScode, and the second field in aSMStext.
This code takes the selected item in the dropdown, and looks at the corresponding element in the second array. It takes that 2nd array value and puts it into cBody which is the text to be used, or edited.

This works exactly as I wanted. It's not complex. I just thought we could perhaps use an array of 2 element arrays. That doesn't appear to be how dbcombo works either.

Thanks.