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