Search the Community

Hello everyone Sorry about my english, Im from Mozambique and its not my mother Language I'm developing in Delphi, I created a birthplace table (id, country_Id, country_name) and city (id, city_Id, city_name) in Xampp, then INSERT INTO country (id, country_id, country_name) VALUES (NULL, '2', 'Brazil'); INSERT INTO city (id, city_id, city_name) VALUES (NULL, '2', 'Rio de janeiro'); INSERT INTO city (id, city_id, city_name) VALUES (NULL, '2', 'Sao Paulo'); INSERT INTO country (id, country_id, country_name) VALUES (NULL, '4', 'USA'); INSERT INTO city (id, city_id, city_name) VALUES (NULL, '4', 'California'); INSERT INTO city (id, city_id, city_name) VALUES (NULL, '4', 'New York'); in the country FDQuery I put it: select * from country; in the city FDQuery I put it: select * from city inner join country where city.city_id=country.country_id; and have city_id city_name country_id country_name 2 Rio de janeiro 2 Brazil 2 Sao Paulo 2 Brazil 4 California 4 USA 4 New York 4 USA Its Ok, But when I select a country in the Lookupcombobox, (eg USA), when I select the city in the city Lookupcombobox it brings all cities, but, coundnt Please Help