Calculation within portal row?
I have two tables... PEOPLE and EVENTS. Within PEOPLE are a number of demographic fields including date of birth, address etc. Within EVENTS are a number of fields that detail things about an event and the people that attended. I have created a relationship between PEOPLE::PERSON_ID and EVENTS::ATTENDEES. By entering the names in the EVENTS::ATTENDEES repeating field, it nicely populates all their demographic info in a portal using the relationship described above.
However... I would like to create a calculation field ATTENDEES::AGE that uses PEOPLE::DATE OF BIRTH and EVENTS::EVENT DATE to calculate the age of each of the attendees at the time of the event and then display the result in the portal row.
I'm just a bit stumped on how to do this. Do i need a separate relationship for the date fields? Any help would be appreciated.