Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Self referenced parent

1136 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Berman
6 - Interface Innovator
6 - Interface Innovator

I have a table with records that self reference to parent records. Is there a way from the parent record to know which records reference it? I know that I can see the relationships in a block but I would like the ability to see children when a record has been referenced as a parent.
Anyone been successful at this?

1 Reply 1
Zollie
10 - Mercury
10 - Mercury

I’m not aware of a way to do that with only linked records. It’s behavior that clearly exists since “child” lists are auto-created when records are in separate tables, but the functionality hasn’t been extended to intra-table relationships.

Alternatives

If only one parent can be assigned to each child, you could group by the linked field and get your answers.

parent1
  child1
  child2

But if a child can have many parents, then those groupings won’t be useful:

parent1 parent2
  child1 child2
parent1
  child3
parent1 parent3
  child4

If it’s a really important bit of information, someone familiar with JavaScript could program a Scripting Block to log the parents and their respective children. But it would need to be periodically run since the scripting block only runs on button click at the moment.