FiveTech Support Forums

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.

Dear Tim,

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

Mr. Tim

That is what DBCOMBO is supposed to do

Please look for samples of DBCOMBO

I looked at the other posts, and also studied dbcombo. Those were really more complex then I need.
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.