Hi
I’m really confused about lookup fields and assumed they worked in a similar way to vlookup in excel and google sheets.
I have two tables:-
Orders
orderidorder namepriceproductidsku
Products
productidproductnamesku
The Orders sku field needs updat...