Product Form displaying summary fields
I have a table that displays product information.
I have an order line table that records details of units IN for each product. One field in this table summarises the no of units of each product (total Line units) This I have added to the product table form layout and it works great.
The problem is that units OUT which is calculated in the tank mix table (units Sum) will not work when added to the same layout.
Why one works and the other doesn't is my question and how to make it work.