>>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

parents in the group header, children in the detail, right?