yes i will list all the competency in one table as mentionedbefore but how do we select the partner for multiple conditions met.

I mean i need to select a partner who is having multiple competency level (Gold Cloud Productivity AND Gold Small and MidMarket Cloud Solutions OR Silver Cloud Productivity)

but i can't list this possibality of selection criteria for all the values.

If u give some more info will be helpful Greg..thanks for for your time