See if similar/identical record exists in another ...

[DonPuissance]

Hi all, 

i need help form you 🙂
i have 2 tables : 
- VariantTable 
-CostTable

The key is the SKU, this field is in the 2 Tables.
I would like to add colunn in VarianTable with the CostPrice.

How to create field with Automaticaly put the CostPrice when SKU is same.

 

 Thanks for you help

[Alexey_Gusev · Accepted solution]

Hi,

•  in VariantTable ,
  - duplicate SKU field,
  - turn 'SKU copy' into Linked to - CostTable,
  - add lookup field with USD