I am creating a database that stores information about machines in a manufacturing plant. Part of that information is pictures. There are a number of cases in which multiple machines require the same picture. At the moment, I am storing the pictures and machine information in a single table, using the attachment data type to store the pictures. The problem is I am storing multiple copies of the same picture in the same database, which seems unnecessarily tedious and resource intensive.
Is there a way I could create a single table to store all my pictures, then be able to reference a given picture in a table or query, so that when I create a form or report based on the table/query, the form/report will display the pictures?
Thanks!