[SOLVED] DBLookupComboBox don't select the ListSource record.

[Galileo]

Hi All.
I'm trying to use a DBLookupComboBox and i can't get it work as expected.

I attached a little example to show the problem.
There are 2 DBF files Clientes (Clients) and Provincias (States).
The Clientes files has a field PROVINCIA_ with the state's id corresponding.

There are two forms. Form1 has a grid and an Edit button. Form2 show the edits fields
and a DBLookupcombobox loaded with Provincia's file.

By default, the DBLookupCombobox don't select the current Provincia.
If you uncomment the following line at event Show it works fine.

//DBLookupComboBox1.KeyValue:=Form1.Dbf_clientes.FieldByName('PROVINCIA_').AsInteger;

There are something else to configure in the DBLookupComboBox's properties to work by default?

I tryied it in Lazarus 1.6.2 in Linux (QT) and Windows 7 (native) and also in Lazarus 1.2.6 on Windows 7.

Thanks in advance.

Eduardo.
           

[howardpc]

You need to give provincias.dbf a primary index on the ID field, and put the name of that index file in the appropriate property before primary-key-lookup based on that field will work as you want.

[Galileo]

Thank you howardpc!

It's working fine now.

Regards. Eduardo.