0

Say I have Tasks and Employees, each with their respective table in the database. There would be a many to many relationship between them, and as such there would be a third table for Assignments.

If I create a listbox that is bound to a AssignmentsBindingSource I do not have the name of the employee to display. Is there a way to get this from a second binding source and use it in the same control?

I am currently binding to a view to accomplish this, but when an employee is assigned to a task, the view will not update the information until the edits are commited to the database and refilled.

Totty
  • 926
  • 2
  • 9
  • 18

1 Answers1

0

Run a query or create a view and use it as the datasource.

Tony Borf
  • 4,579
  • 8
  • 43
  • 51