VLOOK-UP (relationschip)

Question

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 !

donlarson · Answer

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?

Forum Discussion

VLOOK-UP (relationschip)

1 Reply