Hello all,
I am currently developing an access database which will be used to help my department supervisors plan work for the upcoming day as well as document changes on the fly when needed. Right now I a split form that has a column in the datasheet that will allow a supervisor to select a technician from a combo-box to assign them to that specific job. The goal was to have the column just show the techs name, however when you click on the box to select someone else, it displays their name and what qualifications (quals) they have. I have used multi column combo-boxes before so I understand how they work.
The issue is that the linked table that stores the qualifications each employee holds (a linked odbc table) has a separate record for each qualification that a tech holds. What ends up happening is that a Techs name shows up several times on the list depending on how many quals they have instead of displaying their name once and then each qualification in its own column on the same row. Please see the linked photo for a visual explanation of the situation.
Basically the combo-box will only display the active techs from Box 1 in the list to help keep the list small. Box 2 is the linked table that lists the quals for each technician (This linked table only updates the quals and their statuses once a day at midnight, the rest of the time the data is static). Box 3 is a loose idea of what you would ideally see when you click on the combo-box.
Example Photo
Any suggestions would be great.