Compo Boxes Relation

[YaseenIskaf]

Dear all
first Merry Christmas and happy New year for all Members in this Wonderful Site

kindly sick of your help to creating a Query or SQL code

for Example:

I have the first table db named: Countries
and the 2nd table db named : Cities

in the Form Named : Transactions
I have created 2 compo box
the 1st named: Country
and the 2nd named: City

I need to make relation between both db Tables
which can help me in the form to show me only the cities which is under the country I have selected in the 1st compo box

thank you all

[pbaldy]

See if this helps:

Baldy-Cascading Combos