Hi Roi,
>Is that only way to do it...scanning the table and building up a str from each record? I will need to do something similar for a project myself here in a couple weeks.
It's probably one of the simplest ways, but with the Fox there are always *multiple* ways to accomplish the same thing. Text merge comes to mind, along with SET PRINTER TO filename and SET ALTERNATE TO filename.
Building up a string may be just as fast.