Image referenced by other field
I don't want to embed images in the database, I want to point to the appropriate image to display in my layout. Each record has an inventory number which is also the image's filename on my computer.
In my field (Inventory Number) is "1234" which is the unique inventory number of this particular item
The appropriate picture resides at C:\Users\Bob\Documents\Databases\Inventory Pictures\1234.jpg
How do I do that?