Best way to design table for employees with service?
I want to have a database table. Wherein I can add AND remove services for a specific employee? I want to have it as a Gridview with Checkbox.
Example:
Employee1 is selected
Service Gridview (All services for employee)
Service 1 [ ]
Service 2 [x]
Service 3 [x]
etc...
Whats the best way to do that. Im thinking of doing it as a many to many relationship table. Table Service and Table Employee connected by Table Employee Service.. But how am I suppose to show it on the Gridview like the above?
Thanks
Jirr