It's working just fine. You get all entries that either start with MA *OR* have the abbreviation MA. FileMan is doing a multiple cross reference look up.
tjh -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Madhavi Bagepalli Sent: Thursday, June 16, 2005 4:10 PM To: [email protected] Subject: [Hardhats-members] look up not working for STATE file 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 [email protected] https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- 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_idt77&alloc_id492&op=click _______________________________________________ Hardhats-members mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hardhats-members
