Title
Not All Fields Displayed in Table View
Post
I receive tab-delimitted files of test results from our state's K12 testing system.
Each record contains 256 fields.
When I view the data in FileMaker 11's Table View, it only displays the first 60 or so fields.
Is this a limitation of FileMaker?
I was surprised when I experienced it, but it appears to be a limitation, as the layout when viewed in Layout mode shows all records present.
Yes, this is a limitation in FileMaker.
One workaround is to create several such layouts and set them up to display a different subset of the total number of fields. You can then put buttons in the header to select the layout for the "view" you need.
Frankly, 256 fields is a lot of fields for one record definition. Very often, a re-design that moves some of that data into one or more related tables will greatly improve the design of your database.