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โ)
Please help me with that
Many thanks
Solved! Go to Solution.
Have you tried dereference formula likeโฆ [PRODUCT CUSTOMER NAME].[CUSTOMER CODE]
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โ)
Hi
i got the same wrong resultโฆ
Any change that you have more than one value in your Product Customer Name column?
PRODUCT CUSTOMER NAME column is a REF type from table CUSTOMERS so i can only choose from
And you have the same โProduct Customer Columnโ in both tables?
you mean PRODUCT CUSTOMER NAME ? not PRODUCT CUSTOMER COLUMN right ?
if yes no not the same nomination in both tables
Have you tried dereference formula likeโฆ [PRODUCT CUSTOMER NAME].[CUSTOMER CODE]
No How i do that ?
yeah it works !
thank youuu
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]
so i need to add the column CUSTOMER CODE is table PRODUCTS so i can call later right ?
Good
a very easy way to get the unique CODE
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |