AnsweredAssumed Answered

Can't seem to reference related container

Question asked by FMNewbie on Mar 3, 2014
Latest reply on Mar 3, 2014 by philmodjunk

Title

Can't seem to reference related container

Post

     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

     EVENTS::date

     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

     PEOPLE::person_ID

     PEOPLE::date of birth

PHOTOS

     PHOTOS::person_ID

     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..... 

     Cheers. 

Outcomes