Erik --

Guess I'll look into using GenTable. I always did the programmatic update of tables thing with FoxPro 2.x, so there's no reason for me to hesitate to do it with VFP either. Just needed pointing in the right direction.

Thanks for the tip,
Bonnie

>Anyway, the reason am posting is that my strategy now works just as well for me as SDT did for maintaining multiple copies of datastructures:
>
>1. Initially create all tables using the designer.
>2. Use GenTable to write code to create them. Same for views.
>3. Any modifications that have to made to table structure, indexes or views after initial creation are made programmatically.
>
>This program then serves as the synchronization routine. Sure, you have to familiarize yourself with the entire VFP DDL, but you should anyway.