I have a rollup field that gives us a quantity on hand of specific products - referencing an inventory (orders) table. I want to reference that field in the first column - the ID of our product table, so when it is referenced via linked tables, we can see the quantity on hand easily.
However, this causes a circular reference error.
Is there a way to do this?