>>I haven't tried any app generator other that the VFP one, but take a look at Visual ProMatrix.

---

>yes, I have tried the vfp app generator.
>-------
>I am downloading the sample app from ProMatrix.
>thanks...

I used ProMatrix a couple of years ago, excellent product and excellent support. Had an application up and running with security, audit logging, 1 main parent table with 4 child tables, each with their own forms, 10 or so foreign key tables automatically tied in with maintenance forms for them, and several queries/reports. Did the whole thing in less than 40 hours including installing/learning the product. Haven't seen the new version but it is supposed to be even better.