>Colin,
>
>If we took this approach of saving each of the records in the FRX to records in SQL Server, we would add a PK, an identifier for which report it is, and some kind of seqnum to allow us to query the records back out of SQL Server in the same order -- in case the record with printer info has to be the first record (not sure about that). That way, we'd have just one table in SQL Server to handle all of the reports (there are thousands).
>
>After querying into a table, would then have to get the table and memo file named correctly (instead of DBF/FPT)
Not necessary - use any table, copy to whatever.zzx, and its memo will automatically be named whatever.zzt. Fox recognizes the x as the last character of an extension and replaces it with a t for the memo file.