Can't seem to reference related container
I'm putting together a historical database for a family tree of sorts. I would like to arrange it so that people I list in the EVENT::attendees[repeating field] on an EVENT layout are shown in a portal that shows EVENTS::person_age based on EVENT::DATE, as well as the correct PHOTOS::photo that corresponds to their age at the time of the event.
Here are the three tables:
EVENTS::attendees [repeating field] ...related to PEOPLE::person_ID to trigger the portal list. Maybe this is the wrong way to go about this, but it's what I have set up presently.
EVENTS::person_age (defined as [ year (EVENTS::date) - year (PEOPLE::date of birth) ]
PEOPLE::date of birth
PHOTOS::age in photo
PHOTOS::photo (container field)
I relate the PEOPLE::person_ID to EVENTS::attendees and it calculates the corresponding age at the time of the event quite nicely. However, I'm having a hard time figuring out how to relate the PHOTOS:photo container field so it populates in the portal row of the corresponding person.
Let me know if that makes sense and if anyone has any suggestions.....