I am preparing for FileMaker certification exam and came across a test prep question on the internet:
What can be done with an ExecuteSQL calculation function?
A. Count the number of unique values in a field from a set of related records.
B. Populate a field in a set of related records with the result of a calculation function.
The answer is A. But I don't see the difference between the two answers. Could somebody help?
Thanks in advance!