I have a field that pulls a "master" for that record. There can be any combination of "masters" being used. I would like to make a list of the "master" field, but only have it report it once. (i.e. if you have a master 1 (repeats 10 times in the file and a master 4 that repeats 2 times I want a list that reports back master 1 and master 2). This could change on every database I have. Any suggestions?

Well, I figured it out. If anyone wants to know how to do it, you would make a global field with repeating value of 2 then go to field format and make a value list from field and pick your field. You would then make a field as follows: ValueListItems(Status(CurrentFileName), "list value name here") and voila you have every repetition that could possibly happen.