wolfe Posted January 21, 2006 Posted January 21, 2006 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?
Wim Decorte Posted January 22, 2006 Posted January 22, 2006 Make a valuelist of the field and use the "valueListItems" functions to set the global?
wolfe Posted January 22, 2006 Author Posted January 22, 2006 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.
sbg2 Posted January 23, 2006 Posted January 23, 2006 (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 January 23, 2006 by Guest
wolfe Posted January 23, 2006 Author Posted January 23, 2006 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!!!!
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now