Case:
Employee Database
Problem
How can I link the employee pictures automatically to the form?
Employee Database
Table: Betriebspersonal
- Primary Key: Personalnummer (Number)
- Pictures of the employees in a folder (PictureFolder/Personalnummer.jpg)
- Query with the link of the picture as text (Pictures: "PictureFolder\" & [Betriebspersonal]![Personalnummer] & ".jpg")
- Form that should show the picture and further Information about the employee
Problem
How can I link the employee pictures automatically to the form?