>I have 2 tables, one parent and one child, a one to many relationship
>
>parent is having - code and description fields
>child is having - code, date & quantity fields
>
>i'm issuing this command
>
>sele parent.code, parent.description, child.date, child.quantity from parent, child where parent.code=child.code to file myfile
>
>& it gives me a output in a text file, where each and every parent field is repeated, in front of its child record...
>
>is there a way i can get parent field once and below that child records...(i don't want the repetition of parent fields and output should be transfered to txt file.)
>
>
>any help will be highly appreciated, (i don't want to use the report designer only with help of sql or any other command).
>
>thanks in advance...


Create a report and set up group headers and then REPORT FORM myform TO FILE myfile ASCII

HTH