How to "ignore" records in a FIND procedure

[fernando.olmos at hpa.com.au]

Hi everyone. 

How is it possible, with logic, to be able to ignore the occurrence of a
record being retrieved into a cluster, within a FIND procedure?

Obviously the ACCESS and SELECT clauses at the FILE definition level is
the quick answer, but what if you require complex logic to determine,
based on details records, whether a record in a cluster should be
included or not ?

i.e. Here is the rows on my screen ... 
        Account Number  Name 
        1234                    Customer A      -- this customer has 20
detail records where all records are not invoiced

        1235                    Customer B      -- this customer has 10
detail records (orders) where 9 of 10 are flagged as invoiced and the
last rec is not invoiced

        1236                    Customer C      -- this customer has 5
detail records where all records are invoiced. 

I want to use some logic to only display CUSTOMER B in the cluster, on
the screen. 

Fernando Olmos 
MIS 
Senior Analyst Programmer 

HPA
Direct:  03 9217 5411
Mobile: 0410 382 857
Fax:     03 9217 5716 

 <file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au> www.hpa.com.au



**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed.  If
you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060821/0a4010ef/attachment.htm