LOOKUP with wrong result

[bomexport_indus]

Hello,

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
Many thanks

[Aleksi]

You need to add [_THISROW] so your LOOKUP() would understand to read the value from a record where you trigger this formula.

LOOKUP([_THISROW].[PRODUCT CUSTOMER NAME],“CUSTOMERS”,“PRODUCT CUSTOMER NAME”,“CUSTOMER CODE”)

[bomexport_indus]

Hi

i got the same wrong result…

[Aleksi]

Any change that you have more than one value in your Product Customer Name column?

[bomexport_indus]

PRODUCT CUSTOMER NAME column is a REF type from table CUSTOMERS so i can only choose from

[Aleksi]

And you have the same “Product Customer Column” in both tables?

[bomexport_indus]

you mean PRODUCT CUSTOMER NAME ? not PRODUCT CUSTOMER COLUMN right ?
if yes no not the same nomination in both tables

[Aleksi · Accepted solution]

Have you tried dereference formula like… [PRODUCT CUSTOMER NAME].[CUSTOMER CODE]

[bomexport_indus]

No How i do that ?

[bomexport_indus]

yeah it works !
thank youuu

[Aleksi]

When you have a Ref field in your Products table already, you can call what ever column’s value from the Customers table with a deref formula…
[YourRefColumnName].[ColumnNameInCustomersTable]

[bomexport_indus]

so i need to add the column CUSTOMER CODE is table PRODUCTS so i can call later right ?

[Aleksi]

Good

[bomexport_indus]

a very easy way to get the unique CODE