AnsweredAssumed Answered

Portal Issue: Displaying Related Table info

Question asked by ezeitgeist on Aug 29, 2017
Latest reply on Aug 29, 2017 by philmodjunk

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?