>Is the paid flag relevant at all?
Reviewing the requirement, it appears that "Paid" may no longer be relevant.
It is important that billed = YES , becuase this is set to YES only when a claim_no has been generated. The next one is that it could either be a claim_no or an invoice_no. CloseClaims becomes important, becuase if this field is an YES , then the record should not be selected.. Will the last part of the select statement (where it totals the feesubmits and checks to see if the submitted amount is greater than the amt_Paid? i.e. If its an overpayment, I don;t want it to be selected, even if CloseClaim <> YES.
>
>Sidebar...why aren't you using logical fields for these items?
>
The guys who originally worked on this part was quite confused with the .T. and .F. switches, therefore the YES or blank strategy.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons