Keep the text files as separate files, and only maintain a reference (the filename) in a DBF field. >>
Split the DBF file horizontally, for instance by years. >>
Split the DBF file vertically, if you have more than one large field. >>
Use a database server, like Oracle or SQL-Server, as back-end. > >Hilmar, > >I understand how you could easily split the file horizontally as long as there is something logical like years to use. So you would have to have a logical break to do this? Is there a way to have 2 files and have Foxpro use them like they are only 1? Also, how would you handle the verticle split? Common key between them? > >You just got me thinking and now I want to know... :-) > >Renoir