Yet another junction object question!
So for example, I have 2 objects (patients, doctors) joined with a junction (lookup). On the Patient object, I added the doctors related list (junction). When I go to edit the Doctors related list on the Patient page layout, the only fields available are the one Doctor lookup and the system generated fields.
Do I have to bring in ALL Doctor fields (via formula) to the junction object in order to make them available to the related list? Would I also need to do this to enable reporting between the 2 objects?
Thanks!
4 answers
When you create your custom object, make sure to check the 'Allow reporting'. This will auto-create a whole set of report types that you can use. On reports (and validation rules and custom field formulas), you can include fields from related objects without having to create custom fields on the custom object just to hold the values.
