(SOLVED) How to browse lookup exact match?

[Dan Snyder]

Hello everyone,

Ken's solution worked perfectly and best of all it was so simple!

Thank you Ken!!

Dan Snyder
IT Manager
Mercury Electronics
717-428-0222 ext.224


-----Original Message-----
From: filepro-list-bounces+dan=macdatatech.com at lists.celestial.com
[mailto:filepro-list-bounces+dan=macdatatech.com at lists.celestial.com] On
Behalf Of Kenneth Brody
Sent: Tuesday, November 07, 2006 6:55 PM
To: Dan Snyder
Cc: filepro-list at lists.celestial.com
Subject: Re: How to browse lookup exact match?

Quoting Dan Snyder (Tue, 7 Nov 2006 17:22:18 -0500):
> Hello everyone,
>
> I'm trying to display related records from one file in a browse lookup 
> window of another file and I'm having some trouble.  I want the browse 
> window to only show items that are an exact match, but I can't seem to 
> figure out how to do this.  If I use the flags -nxm on the lookup it 
> returns matches and partial matches.  If I use lookup with the -nx 
> flags or no flags it returns every record in the file starting at the 
> first match.
[...]
> Record #1: part #=2850FT
> Record #2: part #=2850FT Potting
>
> I don't want record #2 to display in the browse lookup window.  This 
> is one example of many similar part numbering situations.

Check out PFBRWM=ON.

http://www.fptech.com/Products/Docs/FPFormat/envvars.shtml#PFBRWM

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com