How To Lookup fields from Child to Parent under certain condition

  • 0
  • 1
  • Question
  • Updated 3 months 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 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
I suggest that you post this as a new question.