> code description date qty > 1 desc for code 1 1st Dt for code 1 1st qty for code 1 > 2nd Dt for code 1 2nd qty for code 1 > 3rd dt for code 1 3rd qty for code 1 > 2 desc for code 2 1st dt for code 2 1st qty for code 2 > > where instead of repeating the parent fields, it should blank. > > Pls advs your comments, if it possible to do it through Sql or what is the > best way to do it. I don't want to use scan..endscan. I'm not very sure that SQL is the best way, but if you must do it with sql commands check this out : local lcLastCode lcLastCode = '}}}}' && if the code is char type select ; HideRepValue(a.code) as code,HideRepValue(a.desc) as desc,b.date,b.qty ; from ; main a,child b ; where ; a.code = b.code function HideRepValues lparameter lcFieldValue if lcFieldValue == lcLastCode return space(len(lcFieldValue)) else lcLastCode = lcFieldValue return lcFieldValue endif