About To Get Mad Because Of A Basic SUM
At my database design I have consumers (Consumer_id) and these consumers have invoices (invoice_id) and those invoices have totals (total). I have a different table to sum those invoices due to consumer id and due to month to use it in a script. So I create this relationship as
Concumer_id = Consumer_id
Month = Month
and I created this incredibly basic formula as Sum(consumer::total)
and it doesn't make the basic sum and I can not understand why. I first tried auto enter and after that I tried calculation and it never changes the result.
Can anyone understand why???