Actually, I want to fill a checkedlistbox which is getting its data directly from a fill method in the TemplatesBO.



Currently it is just doing a fillall()



(though I'd still like to know a how to of the previous BO / BO question )



Now, I have a PDFsBO that just represents selected records (same scenario as first question)



Now I want to write a fill method to fill the second checked listbox "Templates" so that no item comes from a record that has a pk matching an itemplateskey found in PDFsBO



I assume I need to pass in a list (or array?) of itemplateskeys found in pdfsBO.



But what is the "Select " statement for the fill that will select only records "where ikey not in (select itemplateskey from parameterarray)")

Not unless you have download or install limitations.  In most environments this should not be an issue.