Project object and Project team object have a master detail relationship. There is a checkbox field named "decision maker" in the project team object and I need this field to be pulled into the project object. I am trying to build a formula field to get this field to link to the project object. But I do not find this field in the formula creation page. What am I missing? Can this be achieved?
Hi Joseph,
I am not sure I understand your use case. If Project Team has a master detail relationship to Project, it means that many teams can be added to a project. Therefore, you cannot just retrieve a field value of a child record on a master record as there is no way to know which record the value must be retrieved from. The only exception are rollup summary fields which aggregate data from the child records on a master record. But I don't think it will help in your case.
