AnsweredAssumed Answered

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

Question asked by DavidGunter on Dec 7, 2012
Latest reply on Dec 7, 2012 by DavidGunter

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?

Steps to reproduce the problem

Tried the same file on a newer Mac. Same result.

Expected result

Form, list and preview should show record detail

Actual result

No records displayed

Workaround

None that I can figure out. Any advice greatly appreciated.

Outcomes