>From a user's poin of view you can do a search
>>D Q^DI
VA FileMan 22.0
Select OPTION: SEARCH FILE ENTRIES
OUTPUT FROM WHAT FILE: STATE//
-A- SEARCH FOR STATE FIELD: 1 ABBREVIATION
-A- CONDITION: MATCHES
-A- MATCHES: 1"MA".E
-B- SEARCH FOR STATE FIELD:
IF: A// ABBREVIATION MATCHES 1"MA".E
STORE RESULTS OF SEARCH IN TEMPLATE:
SORT BY: NAME//
START WITH NAME: FIRST//
FIRST PRINT FIELD: .01 NAME
THEN PRINT FIELD: 1 ABBREVIATION
THEN PRINT FIELD:
Heading (S/C): STATE SEARCH//
DEVICE: INCOMING TELNET Right Margin: 80//
STATE SEARCH JUN 16,2005 16:50
PAGE 1
NAME ABBREVIATION
--------------------------------------------------------------------------------
MASSACHUSETTS MA
1 MATCH FOUND.
Select OPTION:
--- "Sherman, Paul (CEOSH)" <[EMAIL PROTECTED]> wrote:
> OK, time to dust off the mental cobwebs...
>
> FILEMAN looks for all possible matches for the input.
>
> In order to restrict 'overreply', get as close to what you need
> as you can.
>
> For example:
>
> You typed in "MA" - FILEMAN looked for all entries in the STATE field
> and subfields with MA in them ( ala Thomas Holloway's example).
>
> "TN" would only yield Tennessee because no other entry contains
> TN in that configuration
>
> Typing in "MAS" should yield only Massachusetts in this instance.
>
>
> Paul Sherman, CCE
> Biomedical Engineer
> VHA Center for Engineering & Occupational Safety and Health (CEOSH)
>
> Voice: (314) 543-6712 Fax: (314) 543-6749
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Madhavi
> Bagepalli
> Sent: Thursday, June 16, 2005 3:29 PM
> To: hardhats-members@lists.sourceforge.net
> Subject: RE: [Hardhats-members] look up not working for STATE file
>
> Is there a way to make fileman do just a single lookup, instead of
> multiple
> lookup?
>
> >From: "Holloway, Thomas (EDS)" <[EMAIL PROTECTED]>
> >Reply-To: hardhats-members@lists.sourceforge.net
> >To: <hardhats-members@lists.sourceforge.net>
> >Subject: RE: [Hardhats-members] look up not working for STATE file
> >Date: Thu, 16 Jun 2005 16:21:08 -0400
> >
> >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: hardhats-members@lists.sourceforge.net
> >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
> >Hardhats-members@lists.sourceforge.net
> >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
> >Hardhats-members@lists.sourceforge.net
> >https://lists.sourceforge.net/lists/listinfo/hardhats-members
>
> _________________________________________________________________
> 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
>
>
> -------------------------------------------------------
> 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
