Can I create a reverse lookup field from ONE MASTER to MANY DETAILS without need for new relationship?

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

I have a MASTER table (the one) that has an existing relationship to a DETAILS table (to the many).

MASTER(one) < DETAILS(to many)

There is one field stored in the DETAILS table, i.e. [NeedThis], that I need to reference in an exact form using field IDs (FID) from the MASTER table.

Is the only way to get that DETAILS field data into the MASTER table to create a new reverse relationship?  ...so I can create a new lookup field using below relationship?  Or is there an more efficient way to do this?

DETAILS(many) < MASTER(to one)





Photo of troberge

troberge

  • 138 Points 100 badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
Natively, that is the only way. The only other option would require writing "script".

When you ask about Efficiency, I'm not sure if you mean your time efficiency or you are trying to minimize the list on the QuickBase servers.

One day, QuickBase will roll out a feature to do exactly what you want without needing to make a reverse relationship. But until then, we do what we gotta do with tools available to us in a low code environment so we don't need to write code.
Photo of troberge

troberge

  • 138 Points 100 badge 2x thumb
OK Thanks...I was just hoping to not have to create what I saw was a circular relationship.  To me it did not makes sense to create a new relationship just to get a single field, but I guess that's what we have at our disposal, so will give it a try.

Thanks.