How To Lookup fields from Child to Parent under certain condition

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I know this has been answer many times but not finding the exact post/article to get this working.

Parent Record = Opportunity
Child Record = System

System can have multiple "stages" or even multiple system entries. These change over course of design.

Only want to display the system fields on Parent when system (child) has status of "current"
And not a related list but a group of fields that are combination numbers/text etc. 

Basically a reverse lookup but not sure best way to do this - Joined/Third Table?

Current Relation ship is -

Parent                                                          Child  (Key Field here is Record ID)
Opportunity# (numeric key Field)                 Related Opportunity  (Reference)
                                                                     Rel-Opportunity Name (reference proxy)


Thanks for your help!
Photo of IT Support

IT Support

  • 190 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Are you asking how you can float up some text data from some child record(s) up to the Parent record?
Photo of Vincent Wong

Vincent Wong

  • 62 Points
I have the same question too. I would like to know how I can float up some text data from some Child record(s) up to the Parent record

However, the Key field of the Parent is a text field (factory code) and the Key field of the Child is a numeric field (record id).

Thanks. 
(Edited)
I suggest that you post this as a new question.