Just to clarify...
I have three tables set up in a SQL Server database as follows:
job_type
producer
job_prod_split
My app displays all of the rows from the job_type in a datagrid and
all of the rows from the producer table in a checklistbox.
I have a link to job_type and producer via the job_prod_split table
that has en entry for every producer assigned to a job type. I
currently fill the checklistbox a SQLDataReader so I'm not sure if I
can do this easier since I need to fill the checklistbox with all the
producers, and set the qualified producers as 'checked' when the user
selects a job type from the data grid they are displayed.
Please help!!!
Thanks again
-Rich