Jirr Meynor

Jirr Meynor

  • NA
  • 22
  • 0

Best way to design table for employees with service?

Nov 24 2011 2:21 AM
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)