I want our CRM to contain details of all the Vets that we do business with. We need to select a Vet based on what treatments they offer. Certain operations are only available for certain animals. And only certain treatments are available for certain operations.

We need to be able to filter Vets that offer a treatment or operation for a given animal.

So I think what I want to see is a dropdown which shows all the animals. Then - when selected - another dropdown appears which displays all the operations available for that animal. And then when thats selected, it needs to show all the treatments available for that operation. This then shows all the relevant vets.

How best to set this up? Would I have 3 seperate module (Animals, operations, treatments) and then somehow use lookups? Im confused!

Thanks