LookUp Error

[asgweb]

Thanks in advance for your help. I'm defining a field in Products (QuantitySold) with a lookup in LineItems (Quantity) and I get the error

"This lookup uses the field 'QuantitySold' in it's definition. Please choose another field."

This is the only field I need. I'm not sure why I'm getting the error... Thanks

[bcooney]

I would think that you would want in Products the sum of the Quantity sold in Line Items. So, in Products, create a calc field, QtySold = sum( LineItemsbyProductID::Quantity).