I have 12 files with the same unique ID across all.
Ummm... jargon alert. Access doesn't use "files", it uses "tables".
Is there a quick way I
can link each file by this ID without manually dragging every unique ID
between every file in the "Relationships" window?
Well, you could spend half an hour writing and debugging some VBA
code... but!
This seems like a VERY strange table design. One to one relationships
are quite uncommon; *twelve* tables all in a one to one relationship
almost surely is an erroneous design (unless you're doing some really
serious Subclassing; if you don't know the term then you're not!)
One other thing to consider is that even one to one relationships have
a directionality, with a "parent" table related "One to (zero or one)"
to a "child" table. So you really need only nine lines, not the 45
implied by "joining every table to every other".
Could you explain the nature of these tables and their relationships?
I suspect there may be an easier solution.
John W. Vinson[MVP]
