I would like to know how I can establish a calculated field to show me all the data that appears in the index of another field.
You will need to set up a value list based on the field. You can then use the Design functions to get all value list items from the value list.
Javier Sanz wrote:
I have very clear that it should be a global field
Actually, it needs to be an unstored calculation field.
Careful: This works fine if your index is small, otherwise your machine and FM Pro application will be hogged. It may be better for FM12.
If the index has more than 1 billion characters (yes, that exists!), then this technique will fail because of the field size limit.
Another technique is to write a script that extracts your index information by looping through the records and saving it in a separate table.
Discussion on this and other aspects see http://www.filemaker-konferenz.com/2010/downloads/27.%20Mai%20Donnerstag/Riesige%20Datenbanken/FMK%202010%20FileMaker%20Riesige%20Datenbanken%20Information%20Retrieval%20by%20Martin%20Braendle.pdf
Slide 43 and ongoing.