Please help!!!
I have 2 tables โOrders & Productsโ. In orders table, It has column โCustomer name & Product Code 1โ while products table has column โCustomer name & Product ID (data is as same as product code 1โ) & Price".
I want to look up price from the โProductsโ table โPriceโ column to show in โOrdersโ table but there is a problem that Price of the same Product ID is different for different customer.
What will be the app formula for Order table price column? Urgent, pls!!!
Hi @scginternational Check these out.
Thank you.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |