I think I'm making a simple mistake:
3 related tables:
Productions::Project ID <--> SceneList::Project ID
SceneList::Scene_ID <--> ShootingSchedule::Scene_ID
I inserted a Portal in a Productions Table layout that shows ShootingSchedule records filtered by SceneList::Project ID = Productions::Project ID
It lists the correct ShootingSchedule records, but instead of creating calc fields that pull from SceneList records, I thought I could just put SceneList fields in that portal and the info would show up given the relationship setup. I think I may be wrong. Do I need to just create calc fields in ShootingSchedule table? Or is there a different fix?