I need to pull the client #, name, county of residence, and phone numbers from the client table. There are multiple clients per employee.

---

Reply from Richard Rost:

Is there a reason you need to duplicate all of this information? If your relationship is set up properly, all you need is the EmployeeID and the ClientID. All of the rest of the data can just be pulled from the table. This is how I would set it up:

EmployeeT: EmployeeID, FirstName, LastName, etc.
ClientT: ClientID, CompanyName, FirstName, etc.
EmployeeXClientT: ID (key), EmployeeID, ClientID

That's all you need. Unless you need to track HISTORICAL data (like what the client's address was at the time he placed an order), then you don't need to duplicate the information in multiple tables.