AutoComplete Lookup fields OR DBGrid embedded DBLookUpComboBox

[JZS]

Hi all,

Is it possible to make Lookup fields AutoComplete?

My requirement description:

I am forced to use SpreadSheet style (not by choice!) so I have to include DropDownList in on of the columns of a DBGrid (possibility to have more than one column) and the user has to start typing until match is found otherwise the data shall not get posted.

I had several tries on attaching DBLookUpComboBox on the desired column of DBGrid, but had difficulties in the functionality. Generally hard to maintain usability to be nice and friendly.

So finally I tried LookUp fields, it's nice and it saves OK, but one thing that is missing AutoComplete.
It's a must to have AutoComplete as a feature.

So what am after is, a way to have AutoComplete Lookup field. Or nice embedding of DBLookUpComboBox in DBGrid.

Any ideas,

Thanks in advance.

I use Laz1.2 on Win32 with Standard sqldb/mysql ctrls.

[mangakissa]

Jedi has a TjvLookupcombo, which has this ability. But not for Lazarus/FPC.
RXLib has basic the same Lookupcombobox (should be). RXLib is the earlier version of Jedi.

My only problem was; crashing when I tried to select a value in the box.
 

[taazz]

RXLib is the earlier version of Jedi.

that is false, JEDI started up small with jcl and then a number of contribution where made including multiple suits and a lot of smaller single components. After JEDI had enough momentum to sustain it self as a library the RX contribution came after the library was left unattented for a few years. So RX parts are in JEDI library but JEDI has its own history and standing and can not be considered as the RX evolution.

[JZS]

RXLib has basic the same Lookupcombobox (should be).

Tried RXLib, its DBLookUpCombo doesn't interact smoothly as Lazarus' does. Even it has the same issue.

My only problem was; crashing when I tried to select a value in the box.

Users will be selecting values from the box 
I do not want that to be my only problem.

I can not move toward potential catastrophic stage and start all over again.

I prefer Laz default components unless another sufficient solution/component(s) exist.

[mse]

I prefer Laz default components unless another sufficient solution/component(s) exist.

Just for inspiration: MSEgui has tdbwidgetgrid where any edit wiget can be inserted in order to build a data column. For miscellaneous lookup tasks there are tdbdropdownlistedit, tdbdropdownlisteditdb, tdbenumedit, tdbenumeditdb, tdbenumeditlb, tdbenum64editdb, tdbenum64editlb, tdbkeystringedit, tdbkeystringeditdb, tdbkeystringeditlb, tdropdownlisteditdb..., all with "auto completion"  facility.

[JZS]

MSEgui

Sounds interesting, downloaded, waiting to have time for exploring.

@mangakissa,
Interesting package (i.e. RXLib) but seems like I will go with the way of avoid troubles.
Probably avoiding the whole idea of SpreadSheet style and enforce my point of view.

Thank you all.