eric, an old FileMaker "hack" (as it not listed anywhere else that I've seen) is called "multi-line key". Basically, it's a way to have a "join" with more than one match possible without really creating a join table.
If in your main table, you have a calculated key:
if ( not IsEmpty(Field01) ; Field01 & "¶" ; "" )
if ( not IsEmpty(Field02) ; Field02 & "¶" ; "" )
So you have these possibilities:
"" (just nothing)
And you can use this calculated key (called multi-line because of the returns/pilcrow after each "value") on the left side of a relationship (unstored is ok). Match it to the image primary key and you're all set.
Then if field01 has the key, the image shows. If field02 has this key, the image shows. if they both have the same key, one image shows.
Now it gets interesting! If field01 and field02 have DIFFERENT keys, the possibility is there for more than one image. If you show this in a portal, you see both.
Beverly Voth wrote:
eric, an old FileMaker "hack" (as it not listed anywhere else that I've seen) is called "multi-line key".
It's listed in the help:
BTW, the calculation could be simply =
List ( Field01 ; Field02 )
Absolutely! IN the FileMaker Help. You won't find it in Access or SQL or ...
Here's the "12" version, btw <http://www.filemaker.com/12help/html/relational.11.4.html#1027684>
And Michael's List function works beautifully. I hope my "long way around" helped explain why and how it works!
Thanks all for the pointers.
This should do the trick!