Maybe someone else has had a need for this before but I can't find it anywhere.

I'm needing to either print an index list from an indexed field (or) be able to import the contents from the indexed field from all records into a global field.

Any ideas?

Make a valuelist of the field and use the "valueListItems" functions to set the global?

My thought was to keep my question short to avoid clouding what I thought was a simple question. Maybe I need to add a little more detail. It's been said I'm not always clear as glass.

Here's my problem;

I have a database which has a "location" field used to record the loction of an event. This is a regular edit box indexed text field. The problem I have is that we have about eight different people entering data into the field and if someone uses the "enter indexed value" (CTL + I) the index is full of the same locations spelled differently or abbreviated. To describe an intersection like "Main Street and Market Street" I see entries like "Main & Market" "Main St & Market St" and numerous other variations.

Now what I want to do is create a drop down list with using the contents of the field. The problem with this is all the garbage and misspellings and different variations so I want to "clean" the index list up before I impliment the field as a drop down list. To do this, I was thinking I would need to either print the index list or be able to gather the list into a field where I can print it.

Once printed, I can assign someone to modify the location field in all records so they have uniform descriptions for the locations listed.

To get the "Index List" create and use a ValueList of the field as Wim Decorte suggested.

I might suggest making a back-up copy of the file for safety. Then create a new "Columnar list/report" layout with only 1 field... Location. Show All Records, Sort by Location (Ascending) then go to town changing the values.

I would also suggest implementng some standards for entering new locations or else you will be in the same situation another month down the road.

Edited January 23, 200620 yr by Guest

Wow, now don't I feel like an idiot!

I guess I haven't been using my brain enough lately. Gonna have to knock the dust off a little more often I think. lol

Thanks guys!!!!