Both great tools, but xCase can also be nice. It's cheaper and it does a great job of creating and reverse engineering VFP databases. The pro edition can also do SQL Server and Jet among others. Definitely not as powerful as John's recommendations, but something else to consider.
>The two best, IMHO, are PowerDesigner and ErWin. Both kick butt in entity and data modelling with constraints, domains, indexes, scripts, etc. PowerDesigner may be a bit more VFP friendly, though.
>
>>Does anyone know of a good program to design a database in, besides VFP. I want to use a prgram to make a data model.