Hi !
for you who is looking to make a multicriteria search form with combobox and textbox to filter multivalued field you are a the good place. It is not perfect (I'm not a expert), but it works, at least. However, if you select "blue" everything that contains "blue" will appear. Better then nothing ?
You will have to change your multivalued fields into many-to-many relationships. And don't use lookups !
for you who is looking to make a multicriteria search form with combobox and textbox to filter multivalued field you are a the good place. It is not perfect (I'm not a expert), but it works, at least. However, if you select "blue" everything that contains "blue" will appear. Better then nothing ?
You will have to change your multivalued fields into many-to-many relationships. And don't use lookups !