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