Hi,
i have a database containing employees' information. Each employee will belong to one division, one department and up to 3 sections.
My tables are named div, dept, sect, sectII, sectIII.
In my report, i would like to see the employee contact numbers group according to the sections. As such, should one employee belong to 3 sections, his information will appear thrice in the different sections.
Eg.
Section/Role | Name | Mobile No
--------------------------
Sports
Player1 | Michael | 1234567
Player2 | Tammy | 2345678
--------------------------
Arts
Player1 | Michael | 1234567
Player3 | Nicholas | 3456789
---------------------------
Language
Player1 | Michael | 1234567
Player4 | Evelyn | 7654321
i have a database containing employees' information. Each employee will belong to one division, one department and up to 3 sections.
My tables are named div, dept, sect, sectII, sectIII.
In my report, i would like to see the employee contact numbers group according to the sections. As such, should one employee belong to 3 sections, his information will appear thrice in the different sections.
Eg.
Section/Role | Name | Mobile No
--------------------------
Sports
Player1 | Michael | 1234567
Player2 | Tammy | 2345678
--------------------------
Arts
Player1 | Michael | 1234567
Player3 | Nicholas | 3456789
---------------------------
Language
Player1 | Michael | 1234567
Player4 | Evelyn | 7654321