Please explain in more detail why you don't want a summary field. It can do this quite nicely and the getSummary function can access the group's summary values for you.
It's also possible to define a relationship such that aggregate functions, max, min, sum, etc can be used.
Long story short...I am trying to group several records together (based on the ID field), find the minimum of those records, and record that value in another field.
For example, assume the following data:
ID Field 1 A 6 A 3 A 5 B 8 B 2
I want to group all the "A" records together and find and record the minimum value in Field 2 AND I want to group all "B" records together and find and record their minimum value in Field 2. So the database would look like this:
ID Field 1 Field 2 A 6 3 A 3 3 A 5 3 B 8 2 B 2 2
And a summary field, used with getSummary to access the group based sub totals will do that, so why not use a summary field?
GetSummary ( SummaryField ; ID )
will return the summary sub total for groups produce by sorting on ID, the "break field".
The subtotals depend on your current found set and sort order.
A self join relationship can also be used that does not require any sorting, but will pull data for the related group from your entire table, so it may or may not be a better option.
How do I go about using the GetSummary (SummaryField; ID) function?
I was able to create a Summary Field Type (Field 2), which gives me the following data:
ID Field 1 Field 2 A 6 2 A 3 2 A 5 2 B 8 2 B 2 2
Then when I go to create Field 3 (as a calculation type field) with the following calculation "GetSummary (Field 2; ID)" nothing populates Field 3 (i.e., Field 3 is left blank). Should I be doing the GetSummary function somewhere in Field 2?
Did you sort your records by the ID field?
Got it! Thank you!