Summary

Form view will not display any records of imported file. Table view OK.

Product

FileMaker Pro

Version

10

Operating system version

Mac OS 10.5.8 PowerPC

Description of the issue

A list of contacts was imported from Excel into an existing table. The records display in table as expected, but that's all. No form, no preview, no list and no envelope can be created from any of the records- blank screens in all except the table view. Envelope layout can be created but is completely blank of records. The Find functions in table view as expected.

I tried to manually enter some records into the same table, still have same issue with these as well. This table has 3 TO's with relationships and is difficult to isolate.

Another table of contacts in the same file manually entered works fine.

I really need the envelope layout for the first table. How can this be fixed?