Hi im new to sharepoint and i have a very simple problem that i can't do.
I have a products list on my parent site and an orders list on my subsite.
Now i created a site column look up so i can share the products list to my orders list in my subsite.
Now from my orders list i have a quantity field that is needed to be multiplied to the price(the products list has price and item name fields) of the product that is selected item.
I know that you can do calculated column with a lookup value and upon my research the workaround that most people say they did was to create a field in the subsite that will be the holder of the look up value that is needed for the calculated column(in my case the price from the products list from the parent site). Now to do that they said that they use workflow, so upon adding a new item would populate the price value to the look up field.
I've manage to do that but the set up is that the 2 list are on the same site.
And in my case i needed it on different site.
How would you do this?