>I have 2 dbf table each having different fields, type and lengths but have a common field CustID. My aim is to combine both table into a text file in the following order:-
>record 1 of table 1 followed by record 1 to 4 of table 2
>record 2 of table 1 followed by record 5 to 6 of table 2
>record 3 of table 1 followed by record 7 to 9 of table 2
>
>I tried copy to textfile type sdf but I couldn't get what I wanted. Please help. Tks
I guess you may better scan table1 (i hope it's not too big), seek in table2 and combine everything to string variable. When it's finished use STRTOFILE() function to create text file from the variable.
Edward Pikman
Independent Consultant