1
Answer

Best way to design table for employees with service?

Jirr Meynor

Jirr Meynor

13y
1.1k
1
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
Answers (1)