Finding existing records in a many-to-many relationship in Access

By mr_ed_62000 ·
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).


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums