That's the way it was designed (really). There are multiple indices on this file, and you picking up matches found in the index on the state name and also on the state abbreviation. As a programmer, you can restrict the indexes used in a search if need be.
--- Madhavi Bagepalli <[EMAIL PROTECTED]> wrote: > Hi all, > > I am trying to inquire into the STATE file using the ABBREVIATION > field. I > get different results when I use "MA" and "TN" when asked for STATE - > here > is what I get > > Select OPTION: iNQUIRE TO FILE ENTRIES > > OUTPUT FROM WHAT FILE: STATE// > Select STATE NAME: MA > 1 MAINE ME ME > 2 MANITOBA MB MB > 3 MARSHALL ISLANDS MH MH > 4 MARYLAND MD MD > 5 MASSACHUSETTS MA MA > CHOOSE 1-5: > > Select STATE NAME: TN TENNESSEE TN > ANOTHER ONE: > > I get Tennessee state info when I use "TN" abbreviation. But, not or > Massachusetts. I verified if the AABREVIATION field has a cross > reference > and it does. My question is why is the cros reference not working for > look > ups? > > Thanks, > Madhavi > > _________________________________________________________________ > Don?t just search. Find. Check out the new MSN Search! > http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > > > > ------------------------------------------------------- > SF.Net email is sponsored by: Discover Easy Linux Migration > Strategies > from IBM. Find simple to follow Roadmaps, straightforward articles, > informative Webcasts and more! Get everything you need to get up to > speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click > _______________________________________________ > Hardhats-members mailing list > Hardhats-members@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hardhats-members > "The most profound technologies are those that disappear." --Mark Weiser ==== Greg Woodhouse [EMAIL PROTECTED] [EMAIL PROTECTED] ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members