I have the following two forms:

TERMINALS

- Terminal Name

- Cleared Carriers (this is a multi-select lookup field)

- Zone

CARRIERS

- Carrier Name

- Setup: Terminals (The bidirectional lookup of the field above)

What I am trying to do:

I would like to generate a report that shows all of the unique (distinct) carriers in a zone.

TERMINALS.Zone

CARRIERS.Carrier Name 1

CARRIERS.Carrier Name 2

CARRIERS.Carrier Name 3

CARRIERS.Carrier Name 4

CARRIERS.Carrier Name 5

How do I do this? I have tried a lot of different ways but I cannot get the two tables to link correctly and display just the distinct values.

Any help would be GREATLY appreciated. Thanks!