How to avoid duplicating images?


i have a table of exhibitions, and a column with image attachments of various artworks in each exhibition

then i have another table, of artworks. now i want the artworks table to have image attachments of the artworks in all exhibitions they were displayed in

how to do this so i’m not uploading images multiple times?


It sounds like you might need a third table called Installations (or something similar). This would have a record for every instance of an artwork being displayed in an exhibition. It would link to both the Artworks and the Exhibitions tables and contain the picture of the particular artwork in that particular exhibition. You could then use Look Up fields to display the pictures in both the Artworks and Exhibition tables.