BAQ Dynamic Parameter off another parameter

Not sure if this is doable, but I was wondering if it be possible to have a BAQ parameter key off another parameter?

I have a BAQ for MOMs and there are different revs for each MOM. One of the parameter is PartNum and another parameter is Rev. I would like the Rev parameter as a drop down and it would filter/pull the revisions pertaining to the first parameter which is PartNum. Is this doable?

This is not possible in the parameter screen. You may be able to do it as a deployed dashboard

Thanks. Guess no drop down and they will have to type in the Rev.