It works in that I can the two tables I am testing, but it gets only 1 index (and not the correct expression, only the field name).

I select "Database Model Diagram", Under "Database" I select "Reverse Engineer", the "Generic OLE DB Provider", then "Microsoft OLE DB Provider for Visual FoxPro", then the VFP 9 database, I leave all avialable objects checked (Triggers and Check Clauses are grayed out), select to related tables,the store procedures for the tables and non-table specific ones, leave yes check for creating shapes. It then reverse engineers the 2 tables.

Is this how it works?

Will I have to add the correct indexes manually? What about releation ships?

>If the tables were created with 7, 8, or 9 and contain any of the database or table enhancement added in those versions (new fields, DBC events, etc), the ODBC will not work. Use the OLE DB Provider.
>
>>T have vfp 7, 8, and 9 on my PC at work. I would like to document the VFP 0 application. I used the Generic ODBC driver because I did not see the VFP ODBC driver. I get a message say some freatures will may not be availabe (or some thing like that, I am doing this form memory). What I would like to do is reverse emgineer or import the VFP tables. If possible it would be nice to create ET diagrams. Is any of this possible.