Lookup Field drawing from within the same table?

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

I have a Resources table, where a new Resource is added, including a field for who they report to. That field needs to come from the same table (a new resource will report to another resource in the table)?

How do I do this?

thanks

Photo of Ian

Ian

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
You will need to build a Looping Relationship for this to work. This is where a Relationship is built and the Parent table is the same as the Child table.
Photo of Ian

Ian

  • 0 Points
I was trying to avoid that, but seems it's the only option. Thank you