I suggest you make an estimate, how large your biggest table will be after a few years: a) How many records will the largest table have, b) How many MB will your largest table have.
I don't think the the amount will be significant, based on your description so far. VFP can easily handle tables with hundreds of thousands, or even millions, of records; the total size has an absolute limit of 2 GB per file.
>I need to build a medium sized application to process sales, production and shipping.
>
>It will support about 30 users, 100 screens to enter/maintain data, 20 major and 40 minor tables, 1000 to 2000 non-inquiry transactions daily.
>
>I would like to consider using the Foxpro database instead of a third party database.
>
>If you have recent experience in doing something like this, I would like to hear from you about your results including problems you had to overcome in designing and operational reliability after deployment.
>
>Kindest regards to anyone who can contribute.
>
>"Not all who wander are lost."
>- J.R.R. Tolkien
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
