Hi,
I have 2 tables, customers and orders. Table Customers is the data source of mailmerge. It works fine.

Now, I want to show all orders of the corresponding customer. How to do it? I tried to COPY them to foxplus dbf. But I still get the same error

{ DATABASE \d "C:\\temp\\ordersd.dbf" \c "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\\temp\\ordersd.dbf;" \s "select * from ordersd where cnoee = '{ MERGEFIELD cnoee }' " }