I am using FM Pro 11 on Windows 7. I imported the first file from Excel. In browse mode, form, list and table views seem to be correct with correct number of records. In layout mode, an earlier name for data table is indicated and no data is found. What am I doing wrong?
You can't see data in Layout Mode. It's intended for designing a layout, not for viewing and editing the data.
The different table name you mention is a concern here. If you will be importing the data repeatedly, it should always be imported into the same table so that you can see and work with all the data from the same layout.