Obtaining Unique Values only

[Corey-Troy]

In a nutshell, i have a number field named [iD] with 10 repetitions.

Quite often a number will be repeated in more than one of those repetitions.

Each number is related to a record in a separate table.

So what i am trying to achieve is to print ONLY one copy of the record in the table that unique value records[iD] appear.

So for example, in the above values i would end up with 7 printed pages out of the 10 values etc....

How can i achieve this?

[comment]

One way could be to do a Go to Related Record[] step into the "other" table and print from there.

Another option - probably a much better one - would be to eliminate the repeating fields and replace them with individual records in a join table.