I am developing an archaeology database and am trying to relate one photo to multiple records. I am using FileMaker 14 Pro We dig in "units" (i.e. each thing we dig, like a floor, a wall, an ash heap, etc. receives a unit number). One photo might have multiple units in it. I am trying to make it so I can add one photo and relate that photo via a portal to multiple "unit cards." At the moment, I can relate the photo for only one unit but cannot figure out how to add multiple units so the same photo will appear within the portal for multiple records.
Here is an example of what I am trying to do: Picture 1 shows three units: Unit 100 (a floor), Unit 101 (a pit), and Unit 102 (dirt fill). I need to add Picture 1 to my "Photos" database, but I need that photo to appear on the individual record forms (via portal) for Unit 100, Unit 101, and Unit 102.
If my description isn't clear enough, I can grant someone guest access to the database to see what I mean.
Thank you in advance!
I assume you have the photos stored in their own table, and unit cards in their own table. If that is the case, it sounds like you will need a join table to link photos with unit cards. Each join table record stores just the primary ID of the photo and the primary ID of the unit card. This is the standard method of resolving many-to-many relationships.