Skip to main content
Question

VLOOK-UP (relationschip)

  • February 26, 2025
  • 0 replies
  • 39 views

Forum|alt.badge.img

I’ve made in QB a table, where we can search on a specific code and he will give the other related masterdata (out of backtable).

Problem statement:
The problem here is , he can only work with 1 code (80737797) - to reflect the related masterdata, so in case we have multiple codes , we are currently not able to reflect all the codes via this way.
So in this case , Code 80748492 & 80830493 aren’t able to be reflected via the “Related masterdata”-fields.

  • Is there any potential way to have this done within the same “record ID / Line” ?
  • Is there any other opportunity to have the same outcome , but with another workaround.
    I know we can go for multiple record ID’s. But this I would like to avoid as it will create confusion for our partners.

Many thanks !

Forum|alt.badge.img+15
  • Quickbase Alumni
  • February 26, 2025

Before offering any advice, what does the structure of this data look like?

I assume there is a table called Masterdata.   Is your report in the screen capture a child table to that?

Your Users are entering data into a search box that is configured to search the Local Code field?