The attachment is a picture of that design and doesn't change. This isn't a power database, it's simple and only for me, but needs to be portable to my laptop.
I created a blank DB and pulled both main tables and their look-up tables into it. Then started trying to combine them into one main table. So both mains (with attachments) and the combined table (with half the pics repeated) are in there. With all that in the in-progress rebuild, it's just over half a meg. When/if I can pull the other 600 pics into the new main, and the two old tables deleted, I still won't be in any size danger.
I see in the 10 Commandments of Access that I should now abhor look-up tables. In my computer science classes (admittedly years ago), look-up tables were THE method to refrain from mis-typing, mis-spelling, etc., data in a field that's repeated over and over (like the source of one of my designs). I have over 1200 designs but only 51 sources and 12 formats and 27 locations (vital for finding that design when I want it!). Look-up tables!
Back on topic, why does access give us a data type (attachments) that is so different in routine use?
That is rhetorical, I don't expect you to answer.
Thanks for sharing!