Forum Discussion

DN2725's avatar
DN2725
Qrew Member
2 months ago

VLOOK-UP (relationschip)

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 !

Relationships
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    2 months ago

    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?   

Related Content