I have searched and searched and cant find exactly what I need so I'm hoping someone can help.
I am creating a employee database, I have several cascading combo boxes for different selections that take you down to selecting the employee ID. What I would like to do is once the employee ID is selected I want their picture to be displayed. The majority of the employee info is stored in a table called employee details and the pictures are stored in a table called employee files. Both tables contain an employee ID field. The pictures are stored in the table because this file will be used on multiple computers with no shared directories.
I have been able to find answers for pointing to the path of the picture after the combo box is updated but have not seen any code to pull the picture from another table.
I hope I have explained this clearly. Any help would be appreciated.