DBLookupComoboBox that update second DBLookupComoboBox

[fiazhnd]

I was reading this topic http://forum.lazarus.freepascal.org/index.php?topic=28939.0

I have DBLookupComoboBox 1 and 2 and i am using MS Access. my two table name is

tcustomer table
CusID -PK
Name

tcustomercar table
CCarID -PK
CusID -FK
Car

SqlQuery1 (Select*from tcustomer) SqlQuery2(Select*from tcustomercar)


I want when a user selects one customer name in ComoboBox1 it update the ComboBox2 and show only those car which related to selected customer.

[fiazhnd]

Problem solved.

I use two comboBox one on form showevent to load required data from database second one to load data (by using SQL query) on based on first combobox selection. However, i use Combobox2.Items.Addobject which help me to save Foreign Key to my 3rd table.

[mangakissa]

refresh or open/close the lookuptable. This results in a new dataset for the DBLookupcombobox.