I need to create a way to link part numbers in my database to blue prints stored on a server.
The goal is to pick the part number from a drop down on PMI and have it display the print to the screen in either a picture box or with the report plug in.
All the files are stored in the same location so the path will always be C:\Drawings\Blue Prints\‘The name of the file.pdf’. The file name is always the print number as it is stored in the database.
Is there a way to come up with an expresion statement that will point to the correct folder and supply the last part of the file name from the drop down box?