I am working on the following problem - I have a main table "tblAnimals" with fields "id" and "TypeOfAnimal". In that field "TypeOfAnimal" I have different types of animals - "dogs" with id 1, "cats" with id 2, etc. Then I have 2 tables of subspecies of these animals - "tblDogsSubspecies", "tblCatsSubspecies". The table "tblAnimals" is related with "tblDogsSubspecies" and "tblCatsSubspecies" field (foreign key) animal_id.
And the question is how to do the following: When I choose from combobox "cboAnimals" type of animal "dogs" the second combobox "cboSubspecies" to be populated with data from "tblDogsSubspecies".
And the question is how to do the following: When I choose from combobox "cboAnimals" type of animal "dogs" the second combobox "cboSubspecies" to be populated with data from "tblDogsSubspecies".