I’m using LOOKUP expression in table named [PRODUCTS] to get a unique code from another table named [CUSTOMERS].
LOOKUP expression goes to the right Column which is CUSTOMER CODE but give me the wrong CUSTOMER CODE that refers to the PRODUCT CUSTOMER NAME i choose.
This is the expression i’m using :
LOOKUP([PRODUCT CUSTOMER NAME],“CUSTOMERS”,“PRODUCT CUSTOMER NAME”,“CUSTOMER CODE”)
PRODUCT CUSTOMER NAME : is a column in table [PRODUCTS] where i’m using the LOOKUP expression
CUSTOMERS : is the table where LOOKUP expression needs to get the right value from CUSTOMER CODE column
Please help me with that