Categorising the vendor by items in which he deals
We are running a manufacturing unit for which we need various types of raw materials and other industrial spares. We need to add a column in which we can add various items in which a vendor deals. Also we want to filter the vendors by items in which they deal so we may have a complete record and can have a look while sending inquiries to our vendors by simply sorting item wise.