Repeating fields and reports don't mix
Well..... after much reading I just do not know which way to go about this......
This has worked for me ok but in the end, my reports do not reflect what I need because of the repeating fields
any suggestions as to how deal with the new DB?
Originally this was designed on FM5 - now upgrading to FM11 and I want to fix it.
the attached shows an entire order - this is for one customer - one order - qty is a calculation field
I want to be able to get a good report at least of the total for an order - basically a sum of the qty column
The alternative is to use a portal to a related table of records. That's much more flexible and was a better option even with filemaker 5. Reports can then be based on the portal's table with fields from the parent table placed in the header or sub-summary parts.