Joining data from two tables RRS feed

  • Question

  • Greetings.  This is my first post here.  I am a student and have been studying the basics for a year.  Now I am trying to learn things on my own by practicing and making up my own examples. 

    Windows XP Pro SP2
    VS 2005 Standard
    SQL Server Standard
    using Northwind database

    I have a windows application with two list boxes.  listbox1 lists the employees from the employees table.  I would like listbox2 to list the territories for the selected employee.  I am not sure how to join/link the two through the composite/bridge entity.

    I have already set up my tableadapters for Employees, EmployeeTerritories, Territories, and Regions.

    Most of the lessons I have gone through are one table.  I think the above might be a little more real world.

    Any help and advice is appreciated.
    Monday, June 25, 2007 2:13 PM


All replies