I like this approach much better. Agree with indexing the field if you do it often. However, "on the fly searching" seems done quiet well by sorting the field in question and adding a "contains, equal, not equal, greater than etc). Searching sub-files with the "search" option bares little fruit for me.
thurman > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:hardhats- > [EMAIL PROTECTED] On Behalf Of Greg Woodhouse > Sent: Thursday, December 29, 2005 11:54 AM > To: hardhats-members@lists.sourceforge.net > Subject: Re: [Hardhats-members] Searching subfiles with FIND^DIC? > > -- Kevin Toppenberg <[EMAIL PROTECTED]> wrote: > > > I have a question about using FIND^DIC. Specifically, I want to > > search all > > entries in file 50.68 (VA PRODUCT) that contain entry in the subfile > > ACTIVE > > INGREDIENTS (held in field# 14), such that field .01 holds the > > desired > > value. > > > > BTW, if you're going to do this sort of thing often, you might want to > consider creating what is called a whole file cross-reference on the > subfile. These cross-references build an index using both the top-level > IEN and the subentry IEN (as separate subscripts), making it easy to > find those entries containing acetaminophen. > > === > Gregory Woodhouse <[EMAIL PROTECTED]> > "Interaction is the mind-body problem of computing." > --Philip L. Wadler > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click > _______________________________________________ > Hardhats-members mailing list > Hardhats-members@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members