basenine 2/24/2019 4:38:18 PM
Many-to-Many relationships are your friend.
If I'm reading your request properly, to get what you're asking you'll need an identifying column in each table. These columns will be used in the Match Conditions section of the relationship.
In both tables, create [Structure Assignment]. Fill these with A, B, C,......to Z (obviously limited to 26 in English Alphabet....so you do like Excel and go on to AA, BB...). In the images table, every image gets assigned a [Structure Assignment] and likewise in each Edition table, a [Structure Assignment] is assigned.
Then use Match conditions to make [Structure Assignment]=[Structure Assignment].
See how that goes for you.
If you need, send me an invite to a Development Branch of your application, and I'll have a look at it for you. My email is email@example.com...Happy to look free of charge. I will send you a price guide if it's more complex than expected 😀