Jump to content
Sign in to follow this  
sarahd

unable to view all data

Recommended Posts

I have converted a text file to a FileMaker Pro 8.5 file. The file has over 3000 variables (columns) however I am only able to see the first 100 variables when in table layout. I've checked other layout forms and all of the data appears to be there, I just can't view it as a table.

Boss on my case.. help anyone??

Share this post


Link to post
Share on other sites

Table view probably has a limit, and you've exceeded it.

Try this: from the View menu, choose View as List. See if that's better. If not, you'll need to create a Columnar List layout with all the fields on it. The Layout Wizard will walk you through the process.

Share this post


Link to post
Share on other sites

Yep, table view has limit. But if you use List view, it will take forever to scroll through 3,000 fields (if you don't constrain to page width). I suggest you break those fields into logical chunks and display them on different layouts anyway.

Have you ever tried scrolling through over 1,000 fields? I have (not something I designed btw) ... it'll make you blind. By grouping in logical chunks first, it will also help you in organizing your migration needs. I do not believe ANY table should have that many fields. So use layouts to begin breaking the data into tables by displaying in your final table groups.

An easy approach is to first select and place ALL fields on Form layout (let FM create it). Then print only ONE record so you have the field names with an example of the data therein. Highlight or number them on paper by groups first then create your lists from there.

LaRetta

Edited by Guest

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.