Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6944 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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?

Posted

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.

Posted (edited)

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 by Guest
Posted

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!!!!

This topic is 6944 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.