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


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