How to do this kind of relationship?

[sansangtracao]

I have a table with "Employee Name" field, I have another table with "Customer" field. 1 Employee can handle 2 Customer, on the other hand, 2 Employees can share 1 Customer (in a special case). Question: how to handle this problem with table and relationship ? By the way, Employee and Customer in both tables are indexed and cannot be duplicate. Thanks

 

[dhookom]

Create a junction table:
tblEmployeeCustomer
======================
EmployeeID
CustomerID

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[sansangtracao]

Thanks Dhookom, I did not think of that solution