I am working on a movie database. One of the things I would like to do is show the age of the actor at the time of each film. I currently have a lookup that pulls the film year to the actor from the film table, and the actor age on their table. The issue is some actors obviously have done films in multiple years.
Any thoughts of a way to get the age at each film?