Selecting values based on multiple states

[cbushey1]

HI there,

I have a field, RiskFactor, that appears in 3 listboxes, 1 for each alternate state.

RiskFactor can not be selected in the default state.

What I want to do is select another field, Patient_Key, based on the selections made from the 3 alternate states (Risk 1, Risk 2, Risk 3).

Basically, this would give me only those Patient_Key's that have all of the RiskFactors that were selected and NOT just one of them (like a list box does).

[cbushey1]

So this works pretty well.

Is there anyway to get this to just say "87 out of X" instead of listing all the keys (which I think it does because we concatenated them"?

[rwunderlich]

Not that I know of. Perhaps swuehl‌ has an idea.  His article on Compound Search Compound Search - demystifiedis recommending reading as well.

-Rob

[swuehl]

Try adding a second action to your button,  'Selection - Select possible' in field Patient_Key.

[cbushey1]

Thank you that worked!

Thanks for the help guys, appreciate it.