Lookup at the same table

Hi,
How do I Lookup a value in a same table?Im using:

Lookup([Material],Products,Description,Price]
“Material” is a insulm that I am using in a product and both are at the “Products” table.

Your LOOKUP() expression should work so long as the Material column value of the current row matches the entire value of the Description column value of a row in the Products table. Note that the match must be complete (same length, same characters in the same order), but upper- and lowercase are considered equivalent.

1 Like

this is ok but it doesn’t work.
is the syntax correct considering that the fields are in the same table?

1 Like

Ah, good question. Try this instead:

Lookup([_THISROW].[Material],Products,Description,Price)

Hello,
I´ve tried according to your suggestion and its working nice.
I stoped for I while and thats why I delayed to feed back.
Thanks!!

2 Likes