J
jsccorps
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?
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?