Hi Experts,

I have a table which keep data on Vendor list according to the services they provide,as below;
Vendor Table:
VendorID
TypeSupplier (checkbox)
TypeContractor (checkbox)
ServicePrinting (checkbox)
ServiceOutfitting(checkbox)
ServiceMultimedia(checkbox)
ServiceCivil(checkbox)
ServiceConsultancy(checkbox)

These collection of data is use by Procurement staffs, on order to filter which Vendor is providing certain service. For example;
Vendor A. Supplier. ServiceOutfitting. ServiceCivil.
Vendor B. Contractor. ServiceConsultancy. ServiceMechanical.
Vendor C. Supplier. Contractor. ServiceOutfitting.ServiceCivil. ServiceConsultancy.

I had created a form with 2 listbox. One list box(lsBox1) contain all the services. the other listbox(lsBox2) will contain the service selected from LSBox1.

For example I wanted to know which vendor provide Civil or Mechanical, I will choose ServiceCivil and ServiceMechanical from lsBox1(lsBox2.Items.Add(lsBox1.SelectedItem)),now lsBox2 will have the value member of ServiceCivil and ServiceMechanical. My intention is, upon button click, it would be able to return the value as per the listbox value in lsBox2. In this example, Vendor A, Vendor B, Vendor C.

Any way to accomplish this? Or do you have any better ways on how to do this search(do listbox is the correct way?)?

Thanks all.

Jude