hello;

I am testing xmod pro for a client who has a number of excel workbooks to import. I am using SQL Server Management studio to import the excel worksheets, and it imports them and populates all the tables.

The XMOD forms wizard sees the tables but the "Key Field" will not show any fields, so I can't design any forms.

I suspect this has something to do with the imported table not having a key field, but I don't know how to fix that. Google searches haven't been terribly helpful. Does anyone know the answer?