Forum Discussion

Arminx's avatar
Arminx
Frequent Visitor
9 years ago
Solved

LOOKUPVALUE not returning all values

Hi All    My model:          I'm trying to find and store the name of the manager (corresponding to manager_id in employment table) in the employment table. I have added a column bossNam...
Need Help
  • Arminx's avatar
    Arminx
    9 years ago

    Thanks v-haibl-msft that could work, but i ended up merging queries. 

    I'll keep your solution in mind and try it if i come across a similar situation. Thank you!!

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Arminx

 

Maybe you can try to create a duplicate "public employee" table. And you don’t need to create any relationship for this table as below.

 

Best Regards,

Herbert

Arminx's avatar
Arminx
Frequent Visitor
9 years ago

Thanks v-haibl-msft that could work, but i ended up merging queries. 

I'll keep your solution in mind and try it if i come across a similar situation. Thank you!!