>One other thought - if you start with a VFP solution and hundreds or thousands of tables, how well would that scale or migrate to something like SQL Server if/when the time came? I don't have enough knowledge to be sure, but I suspect a SQL backend won't like running with that many individual tables, and creating more all the time.

In my SQL 7 experience, there is not problem in 1500+tables.


regards