Importing info (field content) without duplicates

[Symont]

Hi, I'd like to find a way to import content of a field from every records but I don't want to see the same exact content more than once.

My BD has a lot of bibliographical references here and there (basically everytime an historical information is inserted, there is also a "reference" field). What I want to do, is to have a Bibliography of every reference in one record, but I know that some references are used more than once and I don't want the same reference more than once in the bibliography. If i do a script with a copy and paste, is there a way to tell the script to verify if that reference is already in the bibliography and not to copy/paste it if it is?

Thank

[SlimJim]

If I understand your structure you have "history" records and with each record a field - "Reference" into which you insert (one?) reference. You would like a single field which contains all the references with no repeats. Can I assume the single field is a global? call it Bibliography

First define a Value list "Refs" which is the values of the field reference in BD (show all values). Now define Bibliography = ValueListItems("BD";"Refs"). That should provide you with a list of unique references.

One further point - if you have more than one reference in the field Reference that is not a problem so long as you separate them with carriage returns.