When you say "taken over all records in the database", do you mean in one table or in all tables?
If it is in one table, try this:
Add a duplicate Table Occurrence of your table to your Relationship Graph and relate it to the original Table Occurrence using the cartesian (X) operator. Then use the the Max() function on the duplicate table occurrence name instead of the original.
Depending on your use, a global field on the same table may not recalculate automatically. Use a regular calculation field and do not store the calculation results.
That's very helpful. I did mean all records in one table.
For some reason, the Max() function taken over table 2 returns the most recent entry only (as does Min()). No idea why, bu perhaps it's something to do with my table 1 iself being in a many-to-one link with a main table on which my layout is based.
Anyway, it all works perfectly if I use your idea but switch to a summary field rather than a calculated field.
Yes, the parameter(s) of the Max function must specify a related field, repeating field, or a set of non-repeating fields otherwise it just returns the current record's value.
1 of 1 people found this helpful
If you defined a summary field to compute the "maximum" of your field, references to that field via the your table 2 occurrence would also display the maximum value of all records in the table. You might, for example, add Your_Table 2::SummaryField to a layout based on Your_Table and you'd see the max value for all records in the table.