How to map columns n-n and get data from third table?

See more:

SQL-Server-2005

C#

SQL-Server

, +

Hi i am workin on a webapplication where manager assigns work to the employees from grid..

i have database tables like this

ManagerTable
Customerid
name
and some other columns
EmployeeTable
empid
employeeName
Worktable
CustomerID
EmpID

Database:

Table 1 Table 2
CustomerID | CustomerName|CustomerAddress EmpID |EmpName
--------- -------------------
1 | One |--|-- 1 | EmployeeName
2 | Two 2 | EmployeeName
3 | Three

Table 3
Tb1 | Tb2
---------
// 1 | 1
// 1 | 2
how to insert the column id values in "table3" and get the data in my code i have to use table three ahen employee 1 logins he has a grid which should be filled with data by customer id which matches him

when ever manager assigns check box to a partcualr employee with unique id like(CustomerID,EmployeeID) should be store on a button click in worktable and i have to retriev the data from work table using the IDS stored in the table and show them in grid

when ever a employee logins with his id it should check and get the data assigen to him in a grid all the employees have same web page

can any one help me with querys and code will be most helpfull...