Forum Discussion

PavithraShan's avatar
PavithraShan
Regular Visitor
6 years ago
Solved

Reg - Lookup Issues

Hi,

I have a relationship between two tables Table A and table B. I couldn't take lookup from table A field to table B. Is there any solution to take lookup?

It generates an error like this,

 

 

 

Need Help
  • dax's avatar
    dax
    6 years ago

    Hi PavithraShan , 

    I think this is caused by multiple rows match, if multiple rows match the search values and in all cases result_column values are identical then that value is returned. However, if result_column returns different values an error or alternateResult, if supplied, is returned.

     So you could add alternateResult to remove error. You could refer to my sample for details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi PavithraShan , 

    I think this is caused by multiple rows match, if multiple rows match the search values and in all cases result_column values are identical then that value is returned. However, if result_column returns different values an error or alternateResult, if supplied, is returned.

     So you could add alternateResult to remove error. You could refer to my sample for details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.