Return to FileMaker.com
I have a fairly simple query that works in the data viewer but will not work on a layout showing only "?".
"line_cost" is a calc field with qty x cost. qty and cost are indexed.
I am using "SELECT SUM( line_cost ) FROM TableA". This works in data viewer but never on a layout. Any ideas?
Missed the checkbox to set as Unstored calculation. It is working now.
Retrieving data ...