I am working on improving a database of images with documents on them. Each image can have multiple documents on it and (technically) each document can be represented in multiple images. So I made a table for each and a link table. But when adding a document, for example, when I associate it with an image that already exists in the images table, a duplicate record is created. How do I get Access to find and use the existing records?
A combo/listbox is the usual solution I find, but this doesn’t seem appropriate (4000+ images).
Sincerely.
Alex
