DBLookupComoboBox that update second DBLookupComoboBox
lazarus / 16-Databases

----------------------------------------------------------------------
fiazhnd · 2017-08-06 11:01

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 · 2017-08-08 06:55

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 · 2017-08-08 11:20

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