All experts,

when i retrieving data from the sql server using 'Select' satament with more than one conditions(Say, flag = .f. and Amount > 0
etc...), It retries duplicate records. But i supressed it by using 'Select Distinct statement', And it working fine.

But, In some situations i requred repeated items from the 'detail table'(eg. There is a possiblity of same 'Part No.' can be entred in two times). In this situation how will i fetch the same part nos. ?, The problem is, if i m using simple 'select statement' it wil retrieve duplicate records and if i use 'Select Distinct statement' it will eliminate the second entry of the same item.

please i need someones helping hand in this regard.

regards
Abdulla