Discussions

Expand all | Collapse all

How To Lookup fields from Child to Parent under certain condition

  • 1.  How To Lookup fields from Child to Parent under certain condition

    Posted 06-12-2018 15:41
    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!


  • 2.  RE: How To Lookup fields from Child to Parent under certain condition

    Posted 06-12-2018 15:53
    Are you asking how you can float up some text data from some child record(s) up to the Parent record?


  • 3.  RE: How To Lookup fields from Child to Parent under certain condition

    Posted 08-06-2018 02:19
    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. 


  • 4.  RE: How To Lookup fields from Child to Parent under certain condition

    Posted 08-06-2018 02:20
    I suggest that you post this as a new question.