winforms - C# data bound ListBox -

i have following 2 ms-access tables:

employee table:

employeeid   name

etc.

project table:

projectid   employeeid   projectdescription

each employee can manage 0 or more projects.

i know how use dataset designer add employee table details (multiple bound controls) on form1 (windows form application):

dragging company database's employee table (as details) form creates following components:

• companydataset
• employeebindingsource
• employeetableadapter
• tableadaptermanager
• employeebindingnavigator

how add listbox form1 displays projectdescription of projects displayed employee manages? listbox properties need set?

i believe need following query:
```
select project.projectdescription    project right join employee on project.employeeid = employee.employeeid   employeeid = ?   
```
parameter employeeidtextbox.text
project records created programmatically (oledbconnection, oledbcommand) form2. statement required update form1 when displayed?

i have searched web , read pages , pages of microsoft documentation , have hit wall...

if you're asking how projectdescriptions listbox, iterate through recordset returned query , add each entry listbox

foreach (datarow r in foo) {     projectlistbox.items.add(r["projectdescription"]); }

it's inelegant works. can't promise code though, don't have c# ide test against me. should point in right direction though.

to update form1 after data has been entered form2, put code form1.activated checks updated data , changes objects on form1 appropriately.

KHS