I have 3 text fields labeled committee1, committee2, and committee3; and another 3 text fields labeled committee1Title, committee2Title and committee3Title. I would like to filter all the committee fields to = committee A and all the committee titles to = members with OR statments and am not sure what filter to use. It should be like committee1 = committee A AND committee1Title = members OR committee2 = committee A and committee2Title = members OR committee3 = committee A AND committee3Title = members. I cannot figure out how to do this or what the best filter to use for this. Do you have any suggestions?
I have 3 text fields labeled committee1, committee2, and committee3; and another 3 text fields labeled committee1Title, committee2Title and committee3Title. I would like to filter all the committee fields to = committee A and all the committee titles to = members with OR statments and am not sure what filter to use. It should be like committee1 = committee A AND committee1Title = members OR committee2 = committee A and committee2Title = members OR committee3 = committee A AND committee3Title = members. I cannot figure out how to do this or what the best filter to use for this. Do you have any suggestions?