I cannot seem to get this right but it has been a long week

I have 3 tables

Jobsite - contains info about a job

Equipment - contains a list of equipment (shovels,hard hats etc)

JsEquipment link table for first 2 tables contains a Pk and 2 FK's from each above tables JSE_PK,JBS_FK,EQP_FK

I want to use a checked listbox to allow the user to select which equipment needs to be used on the job. Can you give me a rundown on how to set up the checked listbox. I have tried but failed.. By the way all the primary and foreign keys are guid's

Thanks

P

It's OK to drive on the wrong side of the road sometimes... just as long as your steering wheel is still on the correct side and you don't have to shift with your left hand

This is just standard ListView behavior and we do not add any additional functionality here.  But to use a checked list view, just set the CheckBoxes property to True.  Then to set a ListView checked item it would just be setting the Checked property of the ListVIew item.

You can also referenced the CheckedItems collection to see which items have been checked rather than having to cycle through the Items collection and testing: