Filtered value list

[jim0203]

Say I have a database which was used to control the stock of pets in a pet shop

Animals_table has field "Animal_type" which can be Dog, Cat or Goldfish. Then it has "Animal_breed" which would contain a specific breed.

Dogs_table contains one record per dog in the pet shop. I want to include a pop-up field of Dog breeds, based on the beeds available in "Animals_table". It's obviously trivial to create value list which contains the breeds of all dogs, cats and goldfish, but how do I filter this value list so that it only contains dog breeds?

--Jim

[bcooney]

I think your structure is a bit off. Have a look at this demo.

(Aren't goldfish a breed of fish?)

PetShop.fp7.zip