Hi Sam,

By using the Composite table that includes the Chart of accounts and Department list with each transaction, you are reading 6 files for every transaction record. Since you are displaying the transactions by clicking on another table (presumably the chart of accounts, you don't really need the GL account description in the transaction View. Just changing that should improve the performance a bunch.

Could you use the File | Gather files for support menu choice to package up the Workspace and data and upload it to http://www.softrak.com/dbr to my attention so that I can take a look?

Thanks