Customer DB Setup

Question about the best way to set up a DB.
I would have a form where the manager would (e.g., using check boxes)
indicate services provided and the employees providing the service.
Not clear on the best approach. Should I use three tables:

Customer (with customer information)
Employees (employee information)
Services (list of services that can be provided to a customer)

and somehow associate the customer with the employee providing services?
I'm not sure how to do this.

Or, wouldl it be better to combine the Employee and Services information
into a single table?

TblEmployeeType
EmployeeTypeID
EmployeeType Employee, Manager

TblDepartment
DepartmentID
Department

TblEmployee includes managers
EmployeeID
EmployeeFirstName
EmployeeLasttName
DepartmentID
EmployeeTypeID

TblService
ServiceID
ServiceDesc

TblServiceProvided
ServiceProvidedID
ServiceID
DateServiceProvided
ManagerReportingServiceProvidedID Foreign Key to EmployeeID in
TblEmployee

TblServiceProvidedBy
ServiceProvidedByID
ServiceProvidedID
EmployeeID

Steve



"jsccorps" wrote in message
...
Question about the best way to set up a DB.
I would have a form where the manager would (e.g., using check boxes)
indicate services provided and the employees providing the service.
Not clear on the best approach. Should I use three tables:

Customer (with customer information)
Employees (employee information)
Services (list of services that can be provided to a customer)

and somehow associate the customer with the employee providing services?
I'm not sure how to do this.

Or, wouldl it be better to combine the Employee and Services information
into a single table?