I have developed a system we use internally for keeping track of customer sales info, inventory and receivables. We have now just begun adding a new country, ie Canada, and I need to create new files of customer and receivables information (there will be new fields added), but use existing inventory files.

I have all files currently in a database. Any suggestions on what is the easiest and simplest way to do this? Back in the old Clipper DOS days I used to just create the new files in a new directory and set the path to this directory first, then the existing directory. But the files now are all in a database.

TIA, Peter Renton