How can I create multiple reverse lookup relationships to get info from every Child, without pulling info from same Child twice?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have Parent < Child tables, and Child contains field we'll call 'Child info'.

I need fields in the Parent to list info from all Child records (up to 10, but almost always less--or none), without repeating duplicate info if all Child records have already been 'looked at'. In other words, if there are 4 Child records, Parent lookup fields 6-10 should be blank.

I understand I'll create 10 reverse-lookup relationships from Child to Parent, and 10 fields in Parent, each of which will display info from one Child record.

I need:

  • a way to jump from one Child record to the next, so info from all Children gets listed
  • a way for the lookup fields to be blank if all Child records have already been pulled

Is there a way to do this?

Thank you!!

Photo of Amber

Amber

  • 588 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
This seems overly complex... Typically, if you need to see information from every child record, you would use a Report Link and show only the needed information in an embedded report. Can you explain a bit more about your use case and what you're trying to accomplish?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
If you want to float up values from up to 10 different children, the technique is this.

Creat a summary minimum of the Record ID#.  Can that Record ID#1 of children.
Look that up down to the children.

Duplicate the summary field , but put in a filter where record ID# > Record ID#1 of children.
Look that up down to children.

Repeat, each time changing the filter to be > than the previous Summary minimum.

Then create your 10 reverse relationships.
Photo of Amber

Amber

  • 588 Points 500 badge 2x thumb
We're trying to show as many 'networking' connections through a complicated structure that relates Associates to Clients to Contacts:

Companies < Locations < Contacts < Trust Roles > Clients > Client Assignments > Consultants

When a Contact record is changed, we want all Consultants related to that Contact to be emailed -- and we want the email to contain details on what other Consultants the Contact is related to. The only way for this detail to be included is through a notification email, which means that list of emails for related Consultants needs to be a field in the Contacts table.

We also want to bring the summary/field information of which Consultant each Contact is related to so when we look at a Location record, we can see which Consultants are related to all Contacts at that Location.

Essentially, the more apparent we make the connections between these distant tables, the more we see opportunities for getting new business.
Photo of Amber

Amber

  • 588 Points 500 badge 2x thumb
I did it!!! GORGEOUS!!!!!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
:)
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
Yeah, unfortunately in that scenario, the reverse relationship setup would be the only way to get the usable data that you need. Good to see that Mark's instructions got it resolved for you!