I am currently working on an ID Badge project for my organization.
I have a number of table, the primary is the employee details, and a secondary table tbl_emp_endorsements which contaings all the departments each employee is trained to work in as well as any special skills they have been trained on.
I've enclosed a sample database to give an idea of what I"m working with.
My basic issue is that I can get single field data onto the badge, however when an employee has been authorized tyo work in multiple departments, however do I get this information to populate on one badge? to complicate matters, I have to do this twice as Skills are listed on another line.
Endoresement Section of the badge
FIP REC SHP <----multiple department records by employee
A C D G J <------multiple skill records by employee
So esentially, I want the Badge grouped by employee with a detail section for Departments and one for Skills. Then I need all the data concantenated into a text box.
I hope I was able to explain my intentions well enough. Thanks for any input.