I was watching the video "Synchronize Multiple Related Subforms" and have successfully recreated this in my crafts database for listing by chosen company, but not for listing by tool type. The reason is that I allow multiple values. Some items have more than one product type. For Example: A kit that contains both stamps and dies would have the ProdType of both Stamp and Die listed.
I would like to be able to have this same type of form as the company form where I can choose Stamps on the left and have it show the table with any set that ProdType contains Stamps. How would I do this?