How about if the single mold category were separated into a Mold/Submold pair of categories. That would help with the issue of “I don’t know which H&C” to search for. And it sounds like it would allow old school lookups as well as more refined ones. From a database perspective, it’s easy enough to do... create a field called “submold” and copy whatever is in the “mold” field into the new field. Then the hard part begins, which is changing all the submold fields that have an actual submold.

The last pert is adding the submold field into the query search facility.