1 Reply Latest reply on Feb 23, 2017 10:02 AM by philmodjunk

    Conditional Values list problems


      I've been looking through other discussions that have this same question but since they don't pertain directly to how I want to use the conditional values I can't wrap my head around how to use it.


      I have a mouse database that keeps track of all the mice my lab has ever had, even the dead ones. When you set up a new mating cage you have to specify the ear tag number of the male and female. I have these 2 fields set up as drop down lists currently but in the ear tag field the list shows you the ear tag of every mouse we've ever had. I want it to only show the ear tags for the male mice that are alive. I'll then want to do this same thing for the female mice that are alive.