AnsweredAssumed Answered

Conditional Values list problems

Question asked by lozzib on Feb 23, 2017
Latest reply on Feb 23, 2017 by philmodjunk

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.