Unique Records in FileMaker Revisited… again, part 2 | FileMakerHacks

KEVIN FRANKS continues his series on finding unique records, this time applying the techniques to a more normally designed set of tables:

The demo in part 1 was based on a single “flat table” of data. Today we’re going to unflatten that table, and see how the technique can be applied to a properly normalized system, i.e., with separate tables for Sales, People and Zones, related like so…

This technique can be very useful.  Download the example file and dig in.

Unique Records Revisited… again, part 2 | FileMakerHacks.