LOL...I still can't get away from this one!
Yes, I want to show any vendor that has at least one active, non-expired contract and only show the corresponding Contract numbers for that vendor. What I'm experiencing is that when 1 contract is Deactivated and there is still one or more active, the drop-down is displaying ALL the ...