I am new to SharePoint 2010 but have some excel and access experience. I have a requirement to create an order list(List A) for storing products and quantities. The product field is a lookup column from a product list(List B). The product list also stores the price of the product. I need to create an order where the data from both the lists would be utilized. There is a calculated field in List A which would calculate the total which is [Quantity]* [ListB:product price] from ListB.
Here is what im trying to achieve. I need to create an order list (ListA) for a product and quantity. The product field would be a lookup field to a product in a product list (ListB), which also contains a product price for that product.
Any help would be appreciated. Thanks a lot!