Sorry but I am new to FileMaker Pro and am building my first database
What I am trying to do here is :
In a portal, calculate the quantity, in my line item table with a field ( number that represents a number of parts for this product) in my products table to give me a total of parts needed for this order. I cannot seem to get it to work for me. It keeps returning 0 for the calculation. The field I am selecting is of the related table order_lineitem_product , so I think the relationship is correct.